Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I select the last entry in a sheet, to use in a formula?
Hello,
I have a list of entry's that grows every day. I want to know the substraction of the last entry in the list and the first entry. The position of the first entry is known (b3). The position of the last enty is increased every day. How do I select th last entry? How do I enter this in a formula? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I select the last entry in a sheet, to use in a formula?
=INDEX(Sheet1!B:B,MATCH(9.99999999999999E+307,Shee t1!B:B))-Sheet1!B3 -- Regards, Tom Ogilvy "Rens Duijsens" <Rens wrote in message ... Hello, I have a list of entry's that grows every day. I want to know the substraction of the last entry in the list and the first entry. The position of the first entry is known (b3). The position of the last enty is increased every day. How do I select th last entry? How do I enter this in a formula? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I select the last entry in a sheet, to use in a formula?
=MAX(IF(ISBLANK(A1:A65535),0,ROW(A1:A65535)))
will return the row number of the last row, whereas =INDEX(A:A,MAX(IF(ISBLANK(A1:A65535),0,ROW(A1:A655 35)))) returns the last value. These are both irrespective of numbers or text, and are both array entered, Ctrl-Shift-Enter -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Rens Duijsens" <Rens wrote in message ... Hello, I have a list of entry's that grows every day. I want to know the substraction of the last entry in the list and the first entry. The position of the first entry is known (b3). The position of the last enty is increased every day. How do I select th last entry? How do I enter this in a formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data entry form-select sheet | Excel Discussion (Misc queries) | |||
how do I write a formula to select the last entry in a colum | Excel Discussion (Misc queries) | |||
Linking sheet - Formula Match Exact or select next row and cell | Excel Discussion (Misc queries) | |||
Formula that will record the time and date when an entry is made on a sheet | Excel Worksheet Functions | |||
formula references change when data entry sheet is modified | Excel Worksheet Functions |