I need some help.
I have to find the order which 3 numbers (C2, C3 and C4) occurs in a non ordered range.
See attached file.
The question is that the match is not exact, it varies from -2 to +2 over C2, C3 and C4, like:
AND(>(C2-2);<(C2+2)).
In E2 I need to know the first number that appears on the range A2:A15, then in E3 the second and in E4 the third.
The formula that make some sense (even if they don't work):
=INDEX(A2:A15,MATCH(C2,AND(A2:A15>C3-2,A2:A15<C3+2),0),1)
=INDIRECT("A"&MATCH(AND(>C2-2,<C2+2),A2:A15,0))
Please, I'm really dazed!
Bookmarks