Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Question... LookUP
I am using the follwing formula to calculate the last entry in a range..
=LOOKUP(1,1/(1-ISBLANK('04&05 Details'!C416:C428)),'04&05 Details'!C416:C428) Is there a simple way to calculate the last but one ??? Any help greatly appreciated.. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula question | Excel Worksheet Functions | |||
Multiple Criteria Lookup Question | Excel Discussion (Misc queries) | |||
copying LOOKUP formula | Excel Worksheet Functions | |||
How do I have a formula lookup a sheetname? | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |