Posted to microsoft.public.excel.worksheet.functions
|
|
Return Unique Duplicate Numeric Values across Single Row
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(Data ,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,Da ta))))
Biff
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1
|