Hi
I have a function that return the last non-blank cell in row:
I want now to return the 3 cells before it so at the end I have return the 4 last non-blank cells in the row!
Any one could help?
I have a function that return the last non-blank cell in row:
Code:
=LOOKUP(2,1/(A2:BD2<>""),A2:BD2)
I want now to return the 3 cells before it so at the end I have return the 4 last non-blank cells in the row!
Any one could help?