Thread: how to return mulitple corresponding values
View Single Post
  #59   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default how to return mulitple corresponding values
Hello,

Another approach:
Select a range of 6 rows and 2 columns and array-enter:
=Pfreq(A1:A11,B1:B11)

Pfreq you can find he
http://www.sulprobil.com/html/pfreq.html

Regards,
Bernd
Reply With QuoteReply With Quote