deleting nonadjacent cells

  • Thread starter Thread starter ethniu
  • Start date Start date
E

ethniu

i know that i can select nonadjacent cells, but i can't
seem to find a way to delete them.

i have either 3 columns of names, some duplicates, from
which i'd like to get a list of all the names only once,
without duplicates. i tried moving with unique cells
only. it didn't work.

so i highlighted each list in a different color and
placed them all in one column and sorted them. now i have
all the duplicate names in order and in a different color.
i either want to delete selected non-adjacent cells, or
find a way to go through that list and filter out all the
duplicates.

i'm lost
help
ethniu
 
Back
Top