Dynamic "Numbered List"

  • Thread starter Thread starter Murtaza
  • Start date Start date
M

Murtaza

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]
Click to expand...

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.
 
Back
Top