Find the first number under 60...

[rynny]

Hello

I'm trying find a way to locate the first number under 60 in Column G (desired result highlighted in blue) and which is only for the exact same information across all of Columns A:D.

Screenshot (6).png

Once that number is found, I'd like to put "Y" in the cell in Column I in the same row.

Is this at all possible?

Thanks for your help
rynny

[AliGW]

In I2 copied down:

=IF(AND(G2<60,G1>=60),"Y","")

[rynny]

Thank you so, so, so much AliGW, that works so well... (I love this site haha)

One thing I've just noticed is that if the first number under 60 happens to be in the first row of the new set of data, it remains blank.

I can live with that and just do those manually but wondered if there was a way to include these results in a formula?

Thanks again

[AliGW]

Try this instead:

=IF(COUNTIFS($C$2:C2,C2,$G$2:G2,"<"&60)=1,"Y","")

[rynny]

Thanks AliGW, you've saved me a lot of time, appreciate you help

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.