Show unique data from a row in a cell without duplicates

E

Exanimo96

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find unique data by row 1
Extract unique data across columns in a row. 1
Removing Duplicate Values 1
remove duplicates from one cell that has been combined 0
How to apply a conditional Select distinct (or conditional Where onduplicated cell values in a colum 3
Copy/paste in based on duplicate value in previous row 0
Delete Duplicate codes in a cell 1
Highlighting duplicate cells in a column 2

Top