If the formula returns #N/A when entered as an
array formula, it may mean you don't have any other
values that appear more than once.

If you want the numbers that only appear once to also be listed:

C980 =MODE(rng)

C981 array entered

=IF(ROWS($1:2)<=COUNT(1/FREQUENCY(rng,rng)),MODE(IF(ISNUMBER(rng),IF(COUNT IF(C$980:C980,rng)=0,rng+{0,0}))),"")

C981 copied down until you get blanks

Biff

"Harlan Grove" wrote in message
oups.com...
Ken wrote...
I entered the formula as you listed them and I get a #N/A (Data Not
Available) error. . . .
...
"Harlan Grove" wrote:
...
A1006 [array formula]:
=MODE(IF(COUNTIF(A$1005:A1005,A$3:A$1002)=0,A$3 :A$1002))
...

I did say array formula. That means you need to type the formula, then
hold down [Shift] and [Ctrl] keys before pressing the [Enter] key to
enter the formula. If the formula returns #N/A when entered as an
array formula, it may mean you don't have any other values that appear
more than once.