+ Reply to Thread
Results 1 to 16 of 16

Formula to lookup last number in colum

  1. #1
    Registered User
    Join Date
    08-05-2004
    Posts
    5

    Formula to lookup last number in colum

    I have a bank statement in Excel, I want Excel to look in a specific colum and return the last number of that column. For Exemple, let's say I have values in Column C and values from cell C8 to C55, I want the value in cell C55 to be returned to me in a specific cell!

    I hope my explanation is easy to understand! Hope someone can help.

    Thanks!

    Maggy

  2. #2
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  3. #3
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  4. #4
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  5. #5
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  6. #6
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  7. #7
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  8. #8
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  9. #9
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  10. #10
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  11. #11
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  12. #12
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  13. #13
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  14. #14
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  15. #15
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


  16. #16
    Aladin Akyurek
    Guest

    Re: Formula to lookup last number in colum

    =LOOKUP(9.99999999999999E+307,C8:C65536)

    or

    =LOOKUP(9.99999999999999E+307,C8:C55)

    Diamonelle wrote:
    > I have a bank statement in Excel, I want Excel to look in a specific
    > colum and return the last number of that column. For Exemple, let's
    > say I have values in Column C and values from cell C8 to C55, I want
    > the value in cell C55 to be returned to me in a specific cell!
    >
    > I hope my explanation is easy to understand! Hope someone can help.
    >
    > Thanks!
    >
    > Maggy
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1