Advance Filter in Excel to filter multimple data

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:

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.