Extract unique data across columns in a row.
My Excel 2003 product list contains column titles on row one. Column A has a
unique 11-digit product number. Column B has a current billing code(s) (J3940). Some rows may have no billing code while others have multiple (e.g. J4950, S1299, *C7800, etc). Column C through Column O contain more billing codes, again some may have none while others have multiple. I need to show all 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. |
Extract unique data across columns in a row.
On Tue, 22 Jan 2008 16:11:16 -0800, Exanimo96
wrote: My Excel 2003 product list contains column titles on row one. Column A has a unique 11-digit product number. Column B has a current billing code(s) (J3940). Some rows may have no billing code while others have multiple (e.g. J4950, S1299, *C7800, etc). Column C through Column O contain more billing codes, again some may have none while others have multiple. I need to show all 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. Here's one way. Download and install Longre's free morefunc.xll add-in from http://xcell05.free.fr/morefunc/english/ Then use this formula in P2 and fill down as far as needed: =IF(COUNTA(B2:O2)=0,"",LEFT(MCONCAT(UNIQUEVALUES( B2:O2),", "),-1+FIND(CHAR(1),SUBSTITUTE(MCONCAT( UNIQUEVALUES(B2:O2),", "),",",CHAR(1),COUNTDIFF(B2:O2))))) --ron |
All times are GMT +1. The time now is 12:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com