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
- SEC 54 OF IT ACT
- Is Aadhar PAN linking required for opening bank account?
- Where to show the RCM on Rent paid to unregistered landlord
- Form 26QB for TDS on property
- CPC Processing IT Return for AY 2023-24 without recognizing the Taxation Option under New Regime
- TDS NUMBER SURRENDER
- Payable outstanding for years disallowance
- GST Annual Returns filing due date
- BLOCKED-INELIGIBLE GST CREDIT
- Amendment of September 2021 Invoice
- TDS on social media expenses
- Bonus paid to few employees more than Rs, 10,000 in Diwali
- Provision for Depreciation and profit and loss account
- TAX LIABILITY AGAINST GIFT DEED
- Donation Receipt u/s 80G
- 2B certain data not come 3B & IMS
- Strategic Performance Management and Business Valuation
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
