comparing cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Data>Filter>Advanced 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
Special>Transpose to your desired position.
 
Back
Top