Results 1 to 9 of 9

Thread: Absolute Cell Addressing

  1. #1

    Absolute Cell Addressing



    Register for a FREE account, and/
    or Log in to avoid these ads!

    SALAM
    Hi Every one Hope that all of you are fine.

    How i can use this formula to have the absolute cell address.
    =(ADDRESS(ROW()-1,COLUMN()))

  2. #2
    That is the absolute cell address.

  3. #3
    when one uses this function =INDIRECT(ADDRESS(ROW()-5,COLUMN())) and copy this down this is using relative cell addressing.

  4. #4
    That is a different question.

    So you want a lot of cells to all reference F1? Why not just use =INDIRECT($F$1) in them all?

  5. #5
    Actually i cannot use this

  6. #6
    actually i am trying to fill the missing values (my last post) in the forum. If the last 5 values are missing for any indiviual , i have to fill them. the formula to fill these values is given in column E49 and so on . as i have 65 variables and 84 indiviulas . so i will have to do a lot editing. to aviod tthis i am using the formula in column D see cell D49. but the issue with this formula is that it is using relative cell addressing.

    ((End Value/Start Value)^(1/(Periods - 1)) -1) must be fixed
    Attached Files Attached Files

  7. #7
    Lost me.

  8. #8
    Lost me Mean

  9. #9
    =IF(ISBLANK(INDIRECT((ADDRESS(ROW()-1,COLUMN(),1,1)))),123,321)

    worked for me for copying down.

    *EDIT -- then again I'd generally do a task like this in VBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •