renumber rows after filter command

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.
 
P

Pete_UK

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
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
M

mhoffmeier

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.
 
Top