| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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  -- Diamonelle ------------------------------------------------------------------------ Diamonelle's Profile: http://www.excelforum.com/member.php...o&userid=12756 View this thread: http://www.excelforum.com/showthread...hreadid=389932 |
|
#2
|
|||
|
|||
|
=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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I set up a formula to lookup a value for a condition | Excel Discussion (Misc queries) | |||
| Part Number Lookup | Excel Worksheet Functions | |||
| Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
| Write formula to add "1" to each number in a column | Excel Worksheet Functions | |||
| How do I enter a prefix number to a colum of numbers | Excel Worksheet Functions | |||
Linear Mode
