Thread
:
CORREL w/ condition
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Heidi
external usenet poster
Posts: 75
CORREL w/ condition
I'm trying to use CORREL of 2 columns of data which is based on a conditon of
another column of data. Something like -
IF($a$1:$a$100=1,CORREL($b$1:$b$100,$c$1:$c$100))
Thanks in advance!
Heidi
Reply With Quote
Heidi
View Public Profile
Find all posts by Heidi