Super User Asked by aqua on December 19, 2020
I have the following function:
=IF($C3="I_sc",CORREL(INDIRECT(J2&ROW($C4)&":"&J2&ROW()+MATCH("I_sc",INDIRECT("c"&ROW($C4)&":c2300"),0)),INDIRECT(J1&ROW($C4)&":"&J1&ROW()+MATCH("I_sc",INDIRECT("c"&ROW($C4)&":c"&"2300"),0))),"")
It gives #N/A
as a result. However, when I go through it step-by-step with the ‘Evaluate formula’, at the last step it gives:
What could go wrong here?
Thank you!
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP