A numbered filtered table?

[UK Excel]

I have a table that I need to show the rank of the row, i.e,. 1, 2, 3, 4, 5, 6 and I want it to STILL show 1, 2, 3, 4, 5, 6, etc even if it is filtered

In the uploaded image my unfiltered table is on the left. If I filter it then I get the table in the middle, but I want it the table to look like the one on the right.

How can I do this?

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D
1
2		Rank	Filter
3		1	a
4		2	a
5		3	b
6		4	b
7		5	a
8		6	b
9		7	a
10		8	b
11		9	a
12		10	b
13		11	a
14		12	a
15
Lists

Cell Formulas
Range	Formula
B3:B14	B3	=SUBTOTAL(103,C$3:C3)

+Fluff 1.xlsm
	A	B	C	D
1
2		Rank	Filter
5		1	b
6		2	b
8		3	b
10		4	b
12		5	b
15
Lists

Cell Formulas
Range	Formula
B5:B6,B8,B10,B12	B5	=SUBTOTAL(103,C$3:C5)

 

[UK Excel]

Thanks Fluff, that has done it perfectly.

 

[Fluff]

You're welcome & thanks for the feedback.