Hi,
I have a formula that under the correct circumstances generates a "Buy" signal but otherwise leave the cell blank. Let us assume that this signal is located in cell M1. When I get this signal I need a formula in N2:N6 that compares the value in H1 with the following values in H2:H6. I want the formula to return a "Sell" signal when/if Excel find the first bigger value than H1. If no value is higher than H1 I still want Y6 to signal "Sell".
If for example H3 gives me a "Sell" signal, then H4:H6 must not generate any signal but be blank.
In column M I may find several randomly occasions with a "Buy" signal so I need to be able to copy the formula downwards but to be applied on the separate "Buy" signals.
I am not able to use Match + index since the values must be sorted in date (column B) chronological order.
Is the above even possible and if so, can someone help me?
Thanks in advance!
Jonas
Bookmarks