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) (23512 Points)
17 April 2010
6 Replies
CA CS CIMA Prakash Somani
(Landmark Group)
(23512 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: 216 times
Recent Topics
- LTCG on Foreign RSU Stock sale
- Secure VPN Solution for Freelancers Working with I
- Amount withdrawn from capital gain account scheme
- TDS RETURN REJECTED with Reason Line no 2 –
- Issue in e_filing of IT return
- New India Coop Bank Frozen Account
- GST Registration for export of services under sec2
- Exemption Available or not under new tax regime
- Loss on F & O
- FCNR DEPOSIT INTEREST EARNED REPORTING IN ITR2
Related Threads
Trending Online Classes
CAclubindia
