View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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