Thread: Autofilter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
heater
 
Posts: n/a
Default Autofilter

I have Autofilter on a spreadsheet and once I filter the data, I want that
data to be numbered in sequential order. I have numbered column A from 1 -
100, but after the filter, they are out of order (obviously). Is there a
fromula to put in column A that will automatically number the rows in
sequential order after the filter?