CODEWITHSUNDEEP
excelexcel-formula
Shraddha Avasthy
Shraddha Avasthy

Reputation: 162

Adjacent excel cells show same cell address on using '=cell("address")' formula. Why is that? Shouldn't they have different addresses?

I need the value of cell addresses to implement another solution but I cannot get the correct address. Anyone knows how to fix and get the actual cell address of cells located close to each other.

copying same formula =CELL("address") gives same result for cells with different addresses

Upvotes: 1

Views: 119

Answers (1)

BigBen
BigBen

Reputation: 50143

Use the reference argument:

=CELL("address",L54)

From the docs:

reference: The cell that you want information about.

Optional

If omitted, the information specified in the info_type argument is returned for cell selected at the time of calculation. If the reference argument is a range of cells, the CELL function returns the information for active cell in the selected range.

Upvotes: 2

Related Questions