Number sequence considering filters

[brumby]

Hiya all,

I have a very long list of cells. with everything unfiltered I have a sequential numbering list, 1,2,3,4,5 etc etc

If I decide to filter on something, is it possible for filtered numbering sequence to re adjust taking into account the filter, so originally,

AA1 = 1
AA2 = 2
AA3 = 3
etc etc

when filtered

AA1 = 1
AA553 = 2
AA976 = 3
etc etc?

Many Thanks guys!!

 

[Jon von der Heyden]

Hi

One way:

Lets assume that column AA is available/empty:

By hook or by crook, in column AA, enter the number 1 in each cell all the way down to the end of your table.
In AB1 enter: =SUBTOTAL(109,$AA$1:AA1)
And copy AB1 down to end of range