Louise,

I should have stressed that you need to have all cells showing (the list unfiltered, or use show
all) prior to entering and copying the formula.

HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Louise,

Use this formula in cell A2:

=SUBTOTAL(3,$B$2:B2)

and copy down to match your list. It will update when filtered to always show a correctly
numbered list.

HTH,
Bernie
MS Excel MVP


"Louise" wrote in message
...
Hi all

I have a large worksheet and have set an AutoFilter on the data, to display
the information I need, however, I now need to insert a new column (A) and
number the entries on the filtered list as 1, 2, 3 etc.

When I enter 1 and 2, highlight them both and drag down, it doesn't fill in
with 3, 4 etc. it gives me a list of 1's. I am presuming this is because it
recognises the list is filtered.

Is there any way I can auto-number this filtered list?

THank you.
Louise