i don't think excel's stock vba library provides such a function. you
can either buy a third party library or roll your own.

try the excel programming group for help.

here's an old post that will set you in the right direction:

http://www.exceljockeys.com/forums/f...ay-t12564.html

it's was written to count letter frequency in a string but is
conceptual the same, and easily adapted for, determine the frequency
of unique numbers in cells.

------------------------------------------------------------------------
ExcelJockey's profile: http://www.exceljockeys.com/forums/p...iewprofile&u=4
View this thread: http://www.exceljockeys.com/forums/v...c.php?t=304742