Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

This is super basic, so sorry for that:

If I insert this formula (f.ex.)

=CELL("address")

it shows the current cell address/position - f.ex. $E$5

However, if I insert the same forumula in the row below, the result in both cells change. So, it doesn't show the correct value if I use it more than once. How do I solve this super-basic excel "thing"?

If I f.ex. insert the formula in cells E5 and E6, both cells will show $E$6, instead of $E$5 and $E$6.

EDIT:

I got an answer below, saying that this formula should be used instead:

=ADDRESS(ROW(),COLUMN())

However, this just results in Excel complaining about the forumla having an error...?

EDIT 2:

Replace "," with ";", and it works.

share|improve this question

migrated from stackoverflow.com Mar 1 '13 at 19:34

This question came from our site for professional and enthusiast programmers.

3 Answers 3

up vote 1 down vote accepted

The Cell formula is not the correct formula to get the adress of your cell unless you specify the cells reference as the second argument of the function - But since that is what you want in the first place, the easier way to do it (although there are MANY other ways to do it too), would be:

=ADDRESS(ROW(),COLUMN())

Hope this helps!

share|improve this answer
    
That gives an error. –  user2119841 Feb 28 '13 at 18:34
    
It works when using semi colon instead of comma. –  user2119841 Mar 1 '13 at 9:49
    
The semicolon vs comma issue is due to your Regional Settings and selected list separator character (check Control Panel). The answer given is fine. –  Karan Apr 17 '13 at 13:03

Try =Cell("address",E5) then copy it to other cells: if you don't give a reference Cell gives information about the currently selected cell.

share|improve this answer

From http://www.techonthenet.com/excel/formulas/cell.php

If the range parameter is omitted, the CELL function will assume that you are retrieving information for the last cell that was changed.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.