View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default How to count duplicate or repeat values

Hello Roshlin,

I suggest to use my UDF lfreq:
http://www.sulprobil.com/html/listfreq.html

Press ALT + F11, insert a module, copy my macro text into it, then go
back to your worksheet and you can use lfreq as a function...

Regards,
Bernd