Need a really simple inline macro for a spreadsheet cell - STDDEF, CORREL and MAX with condition as I need to remove the N/A rows from the calculation in a cell range ( single row or column).
I adapted =AVERAGE(B8:B20) to =AVERAGEIF(B8:B20,"<>#N/A")
I need the same for STDDEF, CORREL and MAX with the same condition. Not ISNumber will also work I'm sure.
Need this yesterday so tell me how fast you can do it. :)