renumber rows after filter command

  • Thread starter Thread starter dawnnolan
  • Start date Start date
D

dawnnolan

Does anyone know how to renumber rows after a filter command eliminates
duplicate records. I tried using the edit, fill, series command but my
series option is grayed out.
 
Well, you could put this formula in:

=ROW()

and copy down. It will adjust itself if you delete any other rows.

Hope this helps.

Pete
 
It sounds to me as if you still have the filter applied. Is it?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Does anyone know how to renumber rows after a filter command eliminates
duplicate records.  I tried using the edit, fill, series command but my
series option is grayed out.
Click to expand...

I use COUNTIF(A$1:A100,"<>0") and fill down as needed. I am filtering
for cells that have a dollar amount, you would need to adjust the
criteria for your situation.
 
Back
Top