compare two cells, swap cell contents

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

Guest

I want to compare account numbers in column A. If the numbers are the same
then I want to put the words found in column B into one cell in column C then
delete duplicate account rows.
135490 Yellow Yellow, Red
135490 Red
135490 Yellow
 
Hi Jerry,
This does not exactly do what you ask. Your example is not clear, but I
think I get the general idea. This will not prevent duplicates from
being included.

You can filter duplicate rows out with
Ctrl|A (select all), Data, Filter, advanced filter, [x] unique records only
The select what you see and paste it to another worksheet, because
only the visible filtered rows will be copied.

Joining Codes in Column B to a Product in Column A (#joining)
http://www.mvps.org/dmcritchie/excel/snakecol.htm#joining
 
Back
Top