| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select the last value from a list
This is nicer and more secure than my solution, and it cleared an error in XL
Help, at least in the Hungarian version (so it can be a translation error). Hugarian Help states that if LOOKUP doesn't find the value it returns the greatest (legnagyobb) value in the lookup array. Your formula cleared that it returns the LAST (utolsó) of the array! Thanks, Stefi Ragdyer ezt *rta: Try this: =LOOKUP(99^99,A:A) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steve" wrote in message ... Column A contains a list of numbers. This list will vary in length. Cell C1 needs a formula to display the last (but not necessary largest/smallest) figure in this list. Any help would be appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| with a drop down list in excel how do I select multiple values | Excel Discussion (Misc queries) | |||
| how do I select multi values from a list | Excel Discussion (Misc queries) | |||
| Select every 10th number in a list | Excel Discussion (Misc queries) | |||
| data validation list should have opt. to select based on criteria | Excel Worksheet Functions | |||
| Extracting/look up data from a list and select multiple instances | Excel Worksheet Functions | |||
Threaded Mode
