Thread: Correlations, Group By Type?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Correlations, Group By Type?
Use this array formula as a template
=CORREL(IF(Land="Arctic",Variable1),IF(Land="Arcti c",Variable2))
or see:
http://www.savefile.com/files/1686640
Reply With QuoteReply With Quote