Find unique data by row
 

I'm working on Excel 2003. My product list contains column titles on row
one. Column A has a unique 11-digit product number. Column B has a current
alpha-numeric billing code(s). Some rows in colum B may have no billing code
while others have multiple (e.g. J1234, S5678, *C1111, etc). Column C
through Column O contain more billing codes, again some may have no codes
while others have multiple codes, and of these some are duplicates to any of
the other codes within the other columns.

This is what my file would look like:

Unique product# Current code File1 File2...
UniqueCodes (column P)
12345678901 J1234 J1234 J5678 J1234,
J5678
12345678902 J1234 S1234 *S5678 J1234,
S1234, *S5678
12345678903 *J5678, S1234 S1111 *J5678,
S1234, S1234

I am simply looking for the unique codes at the end of each row in Column P.
My problem is many of the billing codes across the row are repetitive (i.e.
older, current, newer) but I just need those codes that are unique. I know
there is an easy solution, I'm just not that familiar with Excel.

Thanks for any feedback... Yolanda.

Find unique data by row
 

On Tue, 22 Jan 2008 16:18:22 -0800, Exanimo96
wrote:

I'm working on Excel 2003. My product list contains column titles on row
one. Column A has a unique 11-digit product number. Column B has a current
alpha-numeric billing code(s). Some rows in colum B may have no billing code
while others have multiple (e.g. J1234, S5678, *C1111, etc). Column C
through Column O contain more billing codes, again some may have no codes
while others have multiple codes, and of these some are duplicates to any of
the other codes within the other columns.

This is what my file would look like:

Unique product# Current code File1 File2...
UniqueCodes (column P)
12345678901 J1234 J1234 J5678 J1234,
J5678
12345678902 J1234 S1234 *S5678 J1234,
S1234, *S5678
12345678903 *J5678, S1234 S1111 *J5678,
S1234, S1234

I am simply looking for the unique codes at the end of each row in Column P.
My problem is many of the billing codes across the row are repetitive (i.e.
older, current, newer) but I just need those codes that are unique. I know
there is an easy solution, I'm just not that familiar with Excel.

Thanks for any feedback... Yolanda.

Please don't multipost. There is an answer in another NG.
--ron