I have the following Array; =IFERROR(LARGE(Risk_Score,ROW(1:1)),"")
However I only want it to include rows where Risk_Status =Open, I've tried several Large(if( statements but they keep on including rows where Risk_Status is not = to Open.
Solved by D. D. in 15 mins