Spreed sheet???

[Tommy]

I need to make up a spreedsheet to put id numbers in order but!!!! when I
download this information to a spreedsheet and I put them in order which I
do know how to do there are some id numbers that are the same. How can i
tell the spreedsheet to do away with any ID numbers that are the same and
just leave one of those mlti numbers to be counted. aS YOU KNOW ON THE GRID
ON THE LEFT SIDE THERE ARE NUMBERS FROM 1 TO 999999. I need to do away
with any number that is the same that I downloaded , as lone as though there
is one number that was the same remain on the spreedsheet. I am tring to
find out how many id numers there are without countig the numbers that are
the same. Than I will know the total of the ID numbers that are different by
looking to the grid on the left side for total count. Thanks in advance to
all. Tommy

 

[Earl Kiosterud]

Tommy,

Chip Pearson has some macro code for dealing with duplicate rows.
www.cpearson.com.