Creating a numbered list on a filtered worksheet
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
|