ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Show unique data from a row in a cell without duplicates (https://www.excelbanter.com/excel-discussion-misc-queries/174009-show-unique-data-row-cell-without-duplicates.html)

Exanimo96

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.


All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com