Hi, and do feel a little daft asking this as it seems so easy (?).
I have data (numeric e.g. 47 and test e.g. DT) which are entered into a handful of cells in a row.
There are 10 columns (D to M) with the current most recent position as you get to M.
Is there a function that I can enter into Column N to return the entered value closest to Column N i.e.
If Column E has 47, I would like Column N to return 47; If I enter DT into column L, then the value in Column N returns DT.... Likewise if I remove DT from column L the value reverts back to 47.
Searching keeps helping me get the closest value in a different way.
Thank you.
I have data (numeric e.g. 47 and test e.g. DT) which are entered into a handful of cells in a row.
There are 10 columns (D to M) with the current most recent position as you get to M.
Is there a function that I can enter into Column N to return the entered value closest to Column N i.e.
If Column E has 47, I would like Column N to return 47; If I enter DT into column L, then the value in Column N returns DT.... Likewise if I remove DT from column L the value reverts back to 47.
Searching keeps helping me get the closest value in a different way.
Thank you.