pivot would be best, but trying to explain that will take quite some time.

 

I'll try to figure it out Google...

 

ok i'm at work and excel is loaded

-highlight all your data
-click Data then Pivot Table
-click Next then Next
-click Layout
-drag the Name column into the ROW section
-drag the Name column into the DATA Section
-click OK then Finish

simple as that.

 

SWEET! that exacly what i wanted... and cross data too! thank you!

 

edit: didnt see jclau00's post h:



Assuming Column A is your source range
Select Column A
Data -> Filters -> Advanced Filter
Select Copy to Another Location
Keep the 2nd box empty
in the 3rd box, type in the (1st) destination cell, i used B1
Check Unique Entries only.
Click OK

You should now have a 2nd list w/o duplicates
the 1st entry may be duplicated... delete it if it is

next to the 1st entry, enter in this formula =COUNTIF(A$1:A$20,B1)
and drag/expand the formula down.

 

no problem. just tryin to share the wealth man. i stare at spreadsheets 10 hours a day. at least somebody is benefitting from that.

 

:werd:

i learned something new