Hi all,

I am new to the forum and have searched for the answer to my formula query.
Appologies if I have missed an existing solution, a link would be much
appreciated if it already exists.

My knowledge of referencing and look up formulas is very limited. here is
what I thought was a simple function problem:

In a one column vertical array of numbers I wish to find two seperate things.
Firstly the position in the array (from the top down) of the first
occurrence of a number greater than a number in an adjacent cell.
Secondly, the position in the array (from the top down) of the last
occurrence of a number greater than another number in an adjacent cell.

eg:

Array: 6, 9, 3, 4, 2, 8, 8, 2, 7, 5, 6, 1, 4, 3

Adjacent cell contains 7 (first query)

Another adjacent cell contains 5 (Second query)

The answers I am trying to write a formula to obtain are

Query one answer is 2, ie position 2 in the array is the first entry higher
than 7.

Query two answer is 11, ie the 11th entry in the array is the last one
greater than 5.

I suspect the two formulas required are similar uses of multiple referencing
functions.

What my sheet goes onto use from the above is simply "Is the last occurrence
greater than 5 after the first occurance of greater than 7?" True or False
would suffice if it is an easier formula to put together, but I suspect it is
simpler to do it in stages with the two seperate queries and compare the
answers.

Any pointers or formulas to implement the above would be very gratefully
received , I have mused over it for weeks now and it is certainly beyond me.

Thanks

Krapdad

(yes, krap at parenting and also krap at Excel formulas!)