Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More elegant method?
Hi!
Maybe this: =LOOKUP(2,1/(A1:A15<0),A1:A15) 10 22 44 0 0 0 The above formula will return 44. 10 22 44 0 17 0 The above formula will return 17. Biff "RoR" wrote in message ... For each month a number is entered, until it is entered the value for each month is zero. I am trying to pull the latest number greater than zero from the list. Currently I use two nested IF arguments such as: IF(jan0, jan, if(feb0, feb, (if mar0, mar, etc. I'm using two to avoid the limit of nesting logical arguments within logical arguments to 7. Each result reports to a cell with its result, I then do a similar calculation to get the number I really need. Clumsy, but effective. I, however, need a method to get the latest number without using the extra cells, and would like to get it in a more elegant manner. Any suggestions? It's been a very long time since I've written spreadsheets (early 1-2-3, and visicalc, yeah, that long) and I feel that there must be something I'm missing. Thanks in advance. -- Rick R ult replace default with com to email |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
visual fit method | Charts and Charting in Excel | |||
onkey method | Excel Discussion (Misc queries) | |||
problem with the command - method "UpdateFromFile" | Excel Worksheet Functions | |||
Method of running thru these | Excel Worksheet Functions | |||
method and function | Excel Worksheet Functions |