Hi there,

I need some help, a bit stuck here.

1 2 3 4 5
A 40 45 70 78 87

I put this formula down to find the first occurrence thats greater than 50
=COUNTIF($A$1:A1,">"&50)=1 and it worked to pick up the first occurrence more than 50.

But now I want to pick up the last occurrence less than 50. Countif doesnt seem to work and I am kinda stuck now...

Anyone can help?