SPreed sheet formula???

[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

 

[RWN]

One (of many) ways, without resorting to VBA.
Say, for ex, that your ID#'s are in column A1 to A whatever, and that
you've sorted column A.
In col B (or any column for that matter)

Put a zero in B1 -> not really necessary, but keeps it "neat"
In B2 put "=if(A2=A1,1,0)"
Now copy the B2 cell to the end of the list (select B2's fill handle,
hold shift and click)
While the column is highlighted, copy it.
Select B2, select "Paste Special - All" & "OK"
Now Sort column B and delete all the rows with 1's.

 

[RWN]

Tommy;
I made a mistake(!).
The line > "Select B2, select "Paste Special - All" & "OK""
s/b > "Select B2, select "Paste Special - Values" & "OK"

Sorry if it caused any problems.