| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In a column of numbers I need a function to find the last entry
For example I have a column that shows the running balance on a bank account.
I want to find the latest balance which will be on the last populated row of the spreadsheet |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In a column of numbers I need a function to find the last entry
=LOOKUP(2,1/(A1:A10<""),A1:A10)
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Charlie Bamford" wrote in message ... For example I have a column that shows the running balance on a bank account. I want to find the latest balance which will be on the last populated row of the spreadsheet |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In a column of numbers I need a function to find the last entry
it's good practise to put total at the top (fixed cell) for these very
reasons - because you have an expanding list doesn't mean you have to keep re-siting the total "Charlie Bamford" wrote in message ... For example I have a column that shows the running balance on a bank account. I want to find the latest balance which will be on the last populated row of the spreadsheet |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In a column of numbers I need a function to find the last entr
Fantastic!
Thanks for your help "Bob Phillips" wrote: =LOOKUP(2,1/(A1:A10<""),A1:A10) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Charlie Bamford" wrote in message ... For example I have a column that shows the running balance on a bank account. I want to find the latest balance which will be on the last populated row of the spreadsheet |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In a column of numbers I need a function to find the last entry
=lookup(9.99999999999999e+307,a:a) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=541848 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to return last entry in a column series? | Excel Worksheet Functions | |||
| How do I find the last number in a column of numbers? | Excel Worksheet Functions | |||
| Find a empty cell in next column | Excel Discussion (Misc queries) | |||
| Match Function Problem - Won't Find Certain Numbers | Excel Discussion (Misc queries) | |||
| I need to find odd numbers in a column | Excel Worksheet Functions | |||
Linear Mode
