View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Exanimo96 Exanimo96 is offline
external usenet poster
 
Posts: 3
Default Show unique data from a row in a cell without duplicates

I have attempted to submit this same question, but it has not reached the
forum for some reason. Any assistance is most appreciated...

In Excel 2003, I have duplicate billing codes within a row of columns. How
do I show the unique billing codes (removing duplicates) and put the result
at the end of each row?

Original looks like this: J1234 J1234 S9999 *C1234 J1234
How can I make it look like this in the last cell: J1234, S9999, *C1234

How do I remove the duplicates?... thanks in advance for your help... Yolanda.