Hi All,
In an earlier post I received some fantastic help with an Offset index Match formula from member Tony Valko in returning Yes/No if a data-set contained negatives.
I've now got the issue of taking it one step further and searching a data-set for negatives, and if negatives are found comparing the values to the left and offset by 1 below, and returning the highest of these!
The data-set is employee data 61 rows long, however only the top 26 can be compared (fortnightly salary data).
In the example I've attached I've highlighted values to be compared in yellow, with 2 out of 3 containing negatives. The last example doesn't have any negatives and could/would return a "" probably.
I'm generally ok with index match, but I'm stumped at this and haven't found anything close on the forum.
Any help would be appreciated.
Thanks
David
Offset Negative.xlsx
Bookmarks