Excel spreasheet formula
This query is : Resolved
18 January 2016
if spread sheet is very large and in one column two figures (1. left aligned 2. right aligned) are mentioned (one number in one line but column is same) and sum is required separately for left aligned figures only, how to give formula.
11 February 2016
If there is space between these two, you may use Text to column option under data tab by following step , go to data tab>select text to column option>select delimited>next>select comma>then finish...........
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Refund Annexure-B
- Sale of Equity shares for Purchase of Residential Property
- Clarification regarding Import E-way bill transaction type // Regular or Bill from Dispatch From
- GST Reverse
- Liable to deduct tds and 44ADA
- Nomination of Bank for refund in itr 2
- Section 56(2) of the Income tax Act 1961 , Gift to relative .
- Is Interest applicable for payment made through credit ledger vide DRC03 for FY 2020-21 & 2021-22
- Gstr7 vs Gstr3b 2026
- Gst return - cess
- Internship/Academic shown in Salary Pay Slip of a Doctor
- TDS PROCEDURE ON SALE OF IMMOVABLE PROPERTY BY NRI
- Refund of 20%pre-deposit paid for stay application
- ASISSE return under the provisions of the Collection of Statistics Act, 2008 (7 of 2009)
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
