Item wise top ten and top hundred total in excel 2007

Hi tanmanoj

I have spent some time looking at your situation and have come to the conclusion that Excel cannot help.

Let us ignore the fact that one cannot get meaningful figures by adding percentages (as in F4:F10).

Most of the data (columns K-M) comes from the main sheet, but then Horticulture, Street light etc appear from somewhere.

Where columns C-E and G-I are different, I cannot see where Excel will get the information.

I have been able to get a pivot table to give the information, but then I noticed that you are on 2003 where the pivot table is materially different to 2010.

Another way of doing this would have been sumifs (sumif is available in 2003 but sumifs did not come in until 2010 (or maybe 2007) )

Because of all this I am unable to help, and I suspect that others are in the same situation.

I have taken time to reply to you in order that you do not think that you have just been ignored.

Regards
Alastair

Dear Alastair

Forgot result sheet can we do one thing in excel automatically.

create sheet automatically with data like sd code wise sheet and with tarrif wise

example

sheet have data only r31 which have only ap meter data and 2 sheet r31 with ds tarrif data is that possible through macro or else
other wise i have to apply filter and copy the data and then paste in another sheet manually.

thanks
manoj