InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What is the address of first cell and last cell of MS Excel 2010? |
|
Answer» To get the address of the first cell in a named range, you can use the ADDRESS function TOGETHER with the ROW and COLUMN functions.How this formula works The ADDRESS function builds an address based on a row and column number. Working from the inside out, the ROW function returns an ARRAY of absolute* row numbers for a GIVEN range, and the COLUMN function returns an array of column numbers. The ADDRESS function then assembles and returns an array of ADDRESSES. When entered in a single cell, just the item from the array is displayed, which is the address corresponding to the first cell in a range. * By absolute, I mean numbers that TRACK to the entire worksheet, not numbers relative to the range itself.Explanation:please |
|