Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Unique Duplicate Numeric Values across Single Row
Hi All,
I have a Named Range called "Data" that spans 8 columns and 7 rows. A Numeric Value will appear only once in a row. Each row's Numeric Values are in ascending order. A duplicate could be in any column. I would like to Return across a single row unique duplicates (single instance of a duplicate value) in ascending order. Sample Data Layout: 101 102 107 110 145 370 490 501 104 106 130 144 360 430 470 580 125 129 140 150 350 390 460 590 101 102 129 130 149 330 440 578 105 108 120 129 200 280 430 535 100 111 170 175 176 180 420 520 121 189 190 202 229 230 410 521 Expected Results: Unique Duplicate Returned across Single Row 101 102 129 130 430 Thanks, Sam -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search /Filter vertical Numeric pattern (down single column) | Excel Worksheet Functions | |||
Return Row Number of LAST Numeric Consecutive Duplicate in Column | Excel Worksheet Functions | |||
Match 3 Criteria and Return Lowest Numeric Value | Excel Worksheet Functions | |||
Return Single Row of Numeric Data to Single Column | Excel Worksheet Functions | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions |