View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
A volunteer A volunteer is offline
external usenet poster
 
Posts: 1
Default remove duplicates from one cell that has been combined

I have 50 columns. In column 51 I combined the data of each row into one
cell using the concatenate function. I now want to remove the duplicate data
from each cell.

Should I use something else besides concatenate.

I will also have to combine the data of specific columns and then remove the
duplicate data too. for example column 51 I need the unique data from rows B,
D H AA BB AW AU... and in column 52 I need the unique data from C, G, H, K,
....