comparing cell
 

i have a spreadsheet that contain a column of name (some the same and some
not) and would like to place each name in a row acroos the top of the same
spreadsheet.

Smith Jones Brown

Smith
Smith
Brown
Smith
Jones
Jones
Smith
Brown

Hi Stanley

First insert a heading above your column of names.
Then DataFilterAdvanced Filter mark the source as your column of names.
Choose copy to another location and choose a detination cell on the sheet.
Select Unique values only.

Having got a unique list of names, copy this list and Paste
SpecialTranspose to your desired position.

--
Regards
Roger Govier
"Stanley" wrote in message
...
i have a spreadsheet that contain a column of name (some the same and some
not) and would like to place each name in a row acroos the top of the same
spreadsheet.

Smith Jones Brown

Smith
Smith
Brown
Smith
Jones
Jones
Smith
Brown