Filtering of even Text row with that of No.s

[K.Govardhan]

When i am filtering the data i want the name of the party to be displayed in the Sub total Row

As for instance i have shown down that when i am filtering i am getting the subtotal as 81390 & 2034 at the same time i want even rashi jain to be displayed down.

I want it to be displayed like this

Rashi Jain xxxxxxxxxx 81390 and 2034.

Is there any Formula or function to get this...

[pre]

NAME                 PAN              GROSS       TDS DEDUCTED
Rashi Jain	  xxxxxxxxxx        47,850.00       4,785.00
Rashi Jain	  xxxxxxxxxx        24,520.00       2,452.00
Rashi Jain	  xxxxxxxxxx         1,520.00         152.00
Rashi Jain	  xxxxxxxxxx         7,500.00         750.00 

81,390.00       2,034.75

[/pre]
Please help me in this Regard

and do Reply as soon as possible...

 

[sdey73]

K.Govardhan


how would you like to get your data if you filter multiple name of pan number?


regards

sudipta

 

[sgmpatnaik]

@K. Govardhan


Hi


First welcome to Chandoo.org, Glad you are here


Please download the file and check is this correct thing or not actually what you think


https://dl.dropboxusercontent.com/u/75654703/For%20K_Goverdhan.xlsx


Hope it will clear your problem other wise please inform


Thanks


SP

 

[jeffreyweir]

Why don't you just use a pivottable with subtotals?