extract unique numbers

Originally Posted by Ron Coderre

My biggest challenge on this thread was accommodating a unique zero, if they're a posibility.

Good observation, Ron. Using Glenn's first formula, we can replace the part:

COUNTIF($E$4:$J$13,$E$4:$J$13)

with

COUNTIF($E$4:$J$13,$E$4:$J$13&"")

to circumvent this issue, I believe.

Regards