Question

How to find first second third fourth and last, second last, third last & forth last row in an excel

Answer 1

Answer:

Select a blank cell for placing the second to last value,

enter formula =INDEX(B:B,LARGE(IF(B:B<>"",ROW(B:B)

,2))into the Formula Bar, and then

press Ctrl + Shift + Enter keys simultaneously to get the

result.

Note: in the formula, B:B is the column where you will find

the second to last value. You can change it to any column

as you need.

Answer 2

Explanation:

hope it helps plzz mark as brainliest ❤️☺️