| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Unique Duplicate Numeric Values across Single Row
You're welcome. Thanks for the feedback!
Biff "Sam via OfficeKB.com" <u4102@uwe wrote in message news:6c9677aef4055@uwe... Hi Biff, Thank you very much indeed for your assistance. Brilliant Formula solution works Great! Cheers, Sam T. Valko wrote: Here's a tweak that adds an error trap in case there are no duplicates: Array entered in A12: =IF(MAX(COUNTIF(Data,Data))1,MIN(IF(COUNTIF(Dat a,Data)1,Data)),"") Array entered in B12 then copied across until you get blanks: =IF(MIN(IF(COUNTIF(Data,Data)1,IF(DataA12,Data )))=0,"",MIN(IF(COUNTIF(Data,Data)1,IF(DataA12,D ata)))) Biff -- 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 | |||
Threaded Mode
