Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula that uses Last Number in Column of another worksheet
I'd like to create a formula that always uses the value of a formula which is
located in the last cell in a column for a calculation. Also to mention that this is also stored in another worksheet. Entries are made daily so I do not know what the last cell of the column will be. This would help alot so that I do not have to manually change my formula daily. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula that uses Last Number in Column of another worksheet
Try something like this.
=LOOKUP(99^99,Sheet2!A:A) Returns the last number in column A of sheet 2. HTH Regards, Howard "Gladys" wrote in message ... I'd like to create a formula that always uses the value of a formula which is located in the last cell in a column for a calculation. Also to mention that this is also stored in another worksheet. Entries are made daily so I do not know what the last cell of the column will be. This would help alot so that I do not have to manually change my formula daily. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula that uses Last Number in Column of another worksheet
Thanks very much - this works great -
One favor though - could you explain to me what the 99^99 portion of the formula is doing? Thanks again..... "L. Howard Kittle" wrote: Try something like this. =LOOKUP(99^99,Sheet2!A:A) Returns the last number in column A of sheet 2. HTH Regards, Howard "Gladys" wrote in message ... I'd like to create a formula that always uses the value of a formula which is located in the last cell in a column for a calculation. Also to mention that this is also stored in another worksheet. Entries are made daily so I do not know what the last cell of the column will be. This would help alot so that I do not have to manually change my formula daily. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula that uses Last Number in Column of another worksheet
Hi Gladys,
If the value to be looked up is greater than any of the values in the lookup array, LOOKUP will return the last value in the array. So 99^99 is a huge number, one not likely to be in the lookup array, and therefore will return the last value in the column. If you knew for certain that any number in the column would never exceed 100, you could use 101 instead of 99^99 and it would work just the same. Just to add, if you wanted the second to the last value in your column that is changing in length you could use: =LOOKUP(99^99,A:A)-1 HTH Regards, Howard "Gladys" wrote in message ... I'd like to create a formula that always uses the value of a formula which is located in the last cell in a column for a calculation. Also to mention that this is also stored in another worksheet. Entries are made daily so I do not know what the last cell of the column will be. This would help alot so that I do not have to manually change my formula daily. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
=SUMPRODUCT formula help | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |