Thank you, Bernd. Just two questions:

FIRST, your link gives two sample functions. Is the one on the left only
for numbers and the one on the right for text and numbers? What if the list
has blanks?

SECOND, if we define this function and use it on a spreadsheet, will it be
integral to the spreadsheet? In other words, if we copy the spreadsheet to
another location will it still retain all its functionality?

Thanks,
Richard

********************
"Bernd P" wrote in message
...
Hello,

For this I would suggest my UDF lfreq (use only the first output
column = select only one column for the array formula):
http://www.sulprobil.com/html/listfreq.html

Regards,
Bernd