Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jul 2004
    Location
    Sacramento, California, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    cell function (Excel 2000 SP3)

    this function find the correct cell however doesn't product the result I'm look for

    =CELL("CONTENTS",ADDRESS(COUNTIF(C12:C131,">0")+12 ,3,4))

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: cell function (Excel 2000 SP3)

    What are you looking for?

    Steve

  3. #3
    New Lounger
    Join Date
    Jul 2004
    Location
    Sacramento, California, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cell function (Excel 2000 SP3)

    Sorry, the function should give me the contents of the last non-blank cell in a column. It finds the correct address however excel won't except the formula as entered.

    =CELL("CONTENTS",ADDRESS(COUNTIF(C12:C131,">0")+12 ,3,4))

    I get a error message... "The formula you type contains an error."

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: cell function (Excel 2000 SP3)

    How about:
    <pre>=INDIRECT(ADDRESS(COUNTIF(C12:C131,">0")+12,3 ,4))</pre>


    Steve

  5. #5
    New Lounger
    Join Date
    Jul 2004
    Location
    Sacramento, California, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cell function (Excel 2000 SP3)

    The Indirect worked great
    thanks

Posting Permissions

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