Hello!
I need help with {=INDEX(MATCH.....} or something like that formula.
I would like to make a formula that finds the nearest value, of a given cell, in an array of data, and exclude that array member in folowing cell.
Here is an example:
Thank you in advance!
I need help with {=INDEX(MATCH.....} or something like that formula.
I would like to make a formula that finds the nearest value, of a given cell, in an array of data, and exclude that array member in folowing cell.
Here is an example:
Thank you in advance!