Thread: return array formula lookups in to one single cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default return array formula lookups in to one single cell
Hello,

IMHO not possible without VBA because CONCATENATE cannot concatenate
arrays.

I suggest to use my UDF Cfreq:
http://sulprobil.com/html/cfreq.html

Regards,
Bernd
Reply With QuoteReply With Quote