Computer Science, asked by shivamthakur9591, 9 months ago

I am the cell reference of the last cell in an MS Excel 2010 worksheet

Answers

Answered by subbarayulu7949

1

Answer:

Follow below given steps:-

Write the formula in cell B2.

=OFFSET(A1,COUNTA(A:A)-1,0)

Press Enter on your keyboard.

The function will return the value of last non blank cell.

Previous Question

Next Question

Similar questions

Math, 4 months ago

If x varies inversely as y^2 and x = 3 when y = 4, find x when y = 2. please tell me the answer I am giving the answer also please tell me in process ANSWER IS X=12...

Math, 4 months ago

divide - xsquare + 6xcube-3-10x by (2x-3) and find the quotient and remainder also check your answer ...

History, 4 months ago

The northern states of American Civil War wanted to stay in a union why?

English, 9 months ago

This road is more shorter than that. Error correction...

Math, 9 months ago

if 5 th and 9 th terms of an AP be 17 and 29 respectively then it's 25 th term is ...

Science, 1 year ago

shooting stars are also called...

Math, 1 year ago

What is value of iota(i) maths...

Math, 1 year ago

√5 y^2 - 2y + y + 10 : which types of polynomial...