View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Blue Max Blue Max is offline
external usenet poster
 
Posts: 113
Default Returning an array of unique values?

Thank you, Bernd. It looks like this function holds promise. Is the
function returning both a list of values and their frequency? In our case,
we only need the list of unique values or text strings. How is your formula
eliminating the duplicate values and coming up with a list of the unique
values to associate with your frequency counts?

Thank You
Blue
******************
"Bernd P" wrote in message
...
Hello,

You can use my UDF lfreq, for example:
http://www.sulprobil.com/html/listfreq.html

Regards,
Bernd