Excel 2007 : Auto serialing numbers in large filtered data for displaying filtered data

**s.yasir** · 01-12-2011, 02:07 AM

I want my data to be auto serialed as when i put Filter, and displayed results should be shown in serials by available results not the old numbers.

**DonkeyOte** · 01-12-2011, 04:19 AM

See the SUBTOTAL function - specifically COUNTA

If for sake of ex. we assume data being filtered is in say B2:B100 (not blank) and you want adaptive Serial in A2:A100 then:

Please Login or Register  to view this content.

**s.yasir** · 01-12-2011, 05:18 AM

what i need is the data serails should be numbered as new according to display.

like

S.n Name Amount
1 Zain 250,000
2 yuan 100,000
3 charina 97,500
4 George 45,000
5 Paul 3,000

look now if i want to Put filter on Amount Cell as Between 01 and 100,000 should be displayed.
so the items should be displayed automatically with new serials like

S.n Name Amount
1 Paul 3,000
2 George 45,000
3 charina 97,500
4 yuan 100,000

I need the serial Numbers to be arranged automatically not to be taken as original as they were.
About the Subtotal its ok for taking Sum but i need the Serials Arrangement.

Regards

Yasir.