I want to determine how many rows back (from bottom) of a range that you have to go, to find the first value that meets a condition (condition might be >, <, or =). The values in the range are not sorted.
So, if A1:A8 contains:
1, 10, 100, 45, 75, 200, 5, 88
These are the answers i want...