Advance Filter in Excel to filter multimple data
see attached file
Advance Filter in Excel to filter multimple data
CA CS CIMA Prakash Somani (Landmark Group) (23502 Points)
17 April 2010
6 Replies
CA CS CIMA Prakash Somani
(Landmark Group)
(23502 Points)
Replied 17 April 2010
Let me know if any king of excel problem you are facing. or if you feel that can not be there any shortcut to do this in excel !!
Your queries are welcome :) Cheers the helping hand :)
(Guest)
Thanx Boss, I also have something to share related to Excel:
EXCEL TRICKS AND COLLECTION OF EXCEL FILES
Owner : ܔܢܜܔ ∂ιρєѕн♠♠♠ |
satya
(Executive Excise)
(1839 Points)
Replied 21 April 2010
Dear Prakash Somani Ji,
Today I have faced some sorting problem in Excel, my file is having lot of columns, rows, I want to sort it Month wise and Service wise, col. A having Month details, Col.b having Service details, when I tried to do sorting my data, with multiple options tab, it is sorting only either month or service. why? how to solve this?
imkdm
(Student)
(107 Points)
Replied 18 May 2010
Sir,
The data in excel is as follows :
Party Rs.
X 40
Y 50
X 45
Z 79
Z 44
Y 12
X 11
I want to find sum of Rs. for Each Party. Is there any function in Excel ?
(Otherwise I would have to do sorting and sum each party manually).
satya
(Executive Excise)
(1839 Points)
Replied 18 May 2010
Ya! it is Pivot function,
Here I am attaching a Excel file , pl. see it.
Attached File : 46 solution.xlsx downloaded: 190 times
Recent Topics
- Salary Income and Professional services income
- Sec 54 and TDS on sale of property
- Airbnb Manager - I manage properties for owners
- Wrong head ed for late fee
- Inter Company trnafer
- Job work-Reg
- Who is liable to pay GST if bank charges excl GST
- Cost of Acquisition IPO cases
- GST ON RENTAL OF RESIDENTIAL DWELING UNIT ON RCM
- VsV scheme tax payable
Related Threads
Trending Online Classes
-
Landmark Judgments: Important Provisions of the EPF & ESI Act interpreted by the Honorable Supreme Court of India
Mr.Balamurugan Ranganathan15 November 2024
CAclubindia
