Dynamic "Numbered List"

How Can I update my numbered list (S.No) after Filtering the list?

Like:
1. A
2. B
3. C
4. D

After filter.....

1. A
2. B
3. D [C Filtered]


Any Idea to get the result.

Regards,
Murtaza

hi, Murtaza !

> ... update my numbered list (S.No) after Filtering the list?
> Like:
> 1. A
> 2. B
> 3. C
> 4. D
> After filter.....
> 1. A
> 2. B
> 3. D [C Filtered]

assuming [B2] as the first cell [in filtered-column]...
try with subtotal-offset approach [by Laurent Longre] and copy-down...
a) array-entered: {ctrl}+{shift}+{enter} [54 characters]
=sum(subtotal(3,offset($b$2,row($b$2:b2)-row($b$2),0)))
b) non-array [adding 7 more characters]
=sumproduct(subtotal(3,offset($b$2,row($b$2:b2)-row($b$2),0)))

hth,
hector.