Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : How to extract data from columns ? | Excel Discussion (Misc queries) | |||
Excel Workbooks, user returns, extract unique data | Excel Discussion (Misc queries) | |||
Extract data and print in columns | Excel Discussion (Misc queries) | |||
Look up unique value over several columns of data | Excel Worksheet Functions | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) |