Advance Filter in Excel to filter multimple data

Advance Filter in Excel to filter multimple data

 

see attached file


Attached File : 9 advance filter.xls downloaded: 347 times
Replies (6)

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 :)

Thanx Boss, I also have something to share related to Excel:


 

EXCEL TRICKS AND COLLECTION OF EXCEL FILES



Owner : ܔܢܜܔ ∂ιρєѕн♠♠♠ 
311 Members

 

 

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?

resolved already :)

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).

Ya! it is Pivot function,

Here I am attaching a Excel file , pl. see it.


Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details