renumbering rows

[Zack]

After merging several worksheets and removing multiple duplicate records, I
have noticed that many rows jump in sequence (e.g. 1345-1348). For accurate
record counting, how do set my new worksheet so that the row number actually
represents the real record number?

 

[Gav123]

Hi Zack,

Maybe the rows between 1345 and 1348 are hidden. Select the rows, right
click and choose Unhide from the menu.

This maybe a possible answer to your problem.

Hope this helps,

Gav

 

[Zack]

What I would like to see is the actual record count of the unique records,
and toss out the duplicates completely. Is there an easy solution to this?

 

[Sheeloo]

I am assuming that numbers given in your post are record numbers in your date
set after removing duplicates and there are gaps...

If that is the case then (assuming you want the row no. in Column A and have
the lable in A1) do the following;
Enter 1 in A2
Enter =A1+1 in A3 and copy down till end of your data set

Another method;
=Row() - 1 in A2 and copy down... this will be better as you will not have
to renumber if you delete more records.

Let me know whether this was useful.

 

[Gord Dibben]

Data>Filter>Advanced Filter>Unique Reords Only.

You should see a count of unique records on the status bar lower left.

To get rid of duplicates, copy the uniques to another location. Checkmark
that in the first step above.


Gord Dibben MS Excel MVP