fiqs8stwme6s806a

welcome to my space

Refering a cell

January 05th, 2009 | Category: xn--fiqs8stwme6s806a.com
  • Dear all Excel Gurus,

    Suppose I want to access the value of cell a30. Therefore in formula bar I should write: "=$a$30".

    Now suppose this '30' comes from other calculation like : "=count(B1:B30)

    Is there is procedure to directly write "=count(B1:B30)" instead the value 30 like:

    "=$a$count(B1:B30)"?

    I tried with this syntax but got error. I am looking for an alternative of that.

    If anyone give me any suggestion it would be very helpful for me.

    Thanks,
    Arun :rolleye:
    Hyderabad, INDIA


  • Dear vonpookie,

    Thank you very much for your kind attention.

    with regards,
    Arun :bye:


  • You're close, but you need the INDIRECT function:

    =INDIRECT("$A$"&COUNT(B1:B30))







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Refering a cell , Please add it free.
    edit

    Mexico