If your range was named "myData", this formula would count the number
of times the number 1 appears in the range.

=IF(COUNTIF(myData,1)1,"Dupes!","No Dupes")

And this formula (entered as an array w/ Ctrl-Shift-Enter), will let
you know if there are any dupes at all:

=IF(COUNTA(myData)=SUM(1/COUNTIF(myData,myData)),"All Unique","Some
dupes")

Does this help?

--JP


On Mar 31, 1:40*pm, "Sam via OfficeKB.com" <u4102@uwe wrote:
Hi All,

I have a dynamic named range "Data" that spans 8 columns and many rows.
"Data" houses non sequenced numeric values (not ascending or descending order)