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