It already happened that I needed to know the value of the last cell for a column or for a row and this formula will give me the good answer.
When I use the formula ?
To find the value of the last cell, either in a column or in a row.
How to use the formula ?
The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".
How is the formula ?
=LOOKUP()
For a column:
=LOOKUP(2,1/(A:A<>""),A:A)
Explanation:
In case if I want the value of the column B by looking into the column A, I just need to change A:A (the second one) by B:B.
For a row:
=LOOKUP(2,1/(2:2<>""),2:2)
It works as the column, here it is looking into the row 2.
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...