| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I retreive the last # in a column?
I am trying to substract the value in the first cell in a column from the
last value in that column using a function, which i can't find. I want this unknown function to find the last cell with a value in a column , Not a blank cell, and then substract the first cell from it, it will probably go like this: =lastvalue(A:A)-A1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I retreive the last # in a column?
like this:
=lastvalue(A:A)-A1 Try this: =LOOKUP(1E100,A:A)-A1 -- Biff Microsoft Excel MVP "Claudio" wrote in message ... I am trying to substract the value in the first cell in a column from the last value in that column using a function, which i can't find. I want this unknown function to find the last cell with a value in a column , Not a blank cell, and then substract the first cell from it, it will probably go like this: =lastvalue(A:A)-A1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I retreive the last # in a column?
Hi,
You can also try this =LOOKUP(99^99,A:A)-A1 -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Claudio" wrote in message ... I am trying to substract the value in the first cell in a column from the last value in that column using a function, which i can't find. I want this unknown function to find the last cell with a value in a column , Not a blank cell, and then substract the first cell from it, it will probably go like this: =lastvalue(A:A)-A1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I retreive the next date from a column relative to a set c | Excel Discussion (Misc queries) | |||
| Retreive data based on multiple column input | Excel Worksheet Functions | |||
| How can I retreive rows from one column? | Excel Worksheet Functions | |||
| Retreive information from One Sheet to Another | Excel Discussion (Misc queries) | |||
| how do i retreive unsaved work | Excel Discussion (Misc queries) | |||
Linear Mode
