I am working on a formula to pull the row data from column "A", based on the criteria for row "B" and "C".
The criteria is to look for the highest value in Column "B" and the same row "is not blank" in Column "C". In short index the row in column A, with the highest value in column B, that is also not blank in column C.
I keep getting "incorrect argument".
Currently my formula is :
=INDEX(COLLECT({911 Call Date Time Analysis Grid Range 20}, {911 Call Date Time Analysis Grid Range 19}, MAX({911 Call Date Time Analysis Grid Range 19}), {911 Call Date Time Analysis Grid Range 21}, IF(NOT(ISBLANK({911 Call Date Time Analysis Grid Range 21})))), 1)
Call 911 grid range "20" is Column "A"
Call 911 grid range 19 is the first criteria where I'm looking for the highest value: is column "B"
Call 911 grid range 21 is the second column where it needs to be "not blank": is column "C".
Index(Collect(Max- works perfectly, it's just adding in second criteria of looking through column C and looking for the max number with the same row in column "C" not being blank that's causing the error.
