Hi!

I have the following formula:

{=MIN(IF(M2=Product,IF(AM2=PatientID,IF(ROW(L2)<>ROW(FillDate),IF(L2<=FDate,FDate)))))}

This returns the next subsequent date (Column L) given the conditions as set forth. I want it to return the row number of that date, however. There are duplicate dates throughout the sheet. The only way I could figure out how to do it was by using the following formula:

{=IFERROR(MATCH(MIN(IF(M2=Product,IF(AM2=PatientID,IF(ROW(L2)<>ROW(FDate),IF(L2<=FDate,FDate))))),IF(M2=Product,IF(AM2=PatientID,IF(ROW(L2)<>ROW(FDate),IF(L2<=FDate,FDate)))),0)+1,"")}

This, in essence, doubles the amount of time by calculating the array twice. Is there any way to just return the row number using the first formula, other than calculating a whole duplicate array?