| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formula to select the last non-blank cell in a list
You're welcome.
Pete On Mar 24, 11:52*pm, BROCK8292 wrote: perfect thank you "Pete_UK" wrote: Just use MAX, like this: =MAX(A2:A50) Hope this helps. Pete On Mar 24, 11:16 pm, BROCK8292 wrote: is there a way to return the largest number instead of the last? that would actually work better for me "Dave Peterson" wrote: It returns the last number in that range--not the largest number in the range. Fred Smith wrote: The formula tells Excel to find the number 1e100 in the range A2:A100. 1e100 is a very large number (10 to the 100th power). As there is no number that large in the range, Excel returns the largest number it finds. Regards, Fred. "BROCK8292" wrote in message ... thats incredible, thank you very much im sure youre busy but if you get a chance i would love to know why that works br "T. Valko" wrote: Try this: =LOOKUP(1E100,A2:A100) Format as DATE -- Biff Microsoft Excel MVP "BROCK8292" wrote in message ... Im trying to select the last date in each of about 1000 seperate 50 row lists in a worksheet using a single cell at the top. Is there a formula that can do this? thank you, barry -- Dave Peterson- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select the last cell in a long list | New Users to Excel | |||
| Select End of list in formula? | Excel Worksheet Functions | |||
| select list by selecting a cell | Excel Worksheet Functions | |||
| How do I select & use contents of first non-blank cell in row? | Excel Worksheet Functions | |||
| I want to select the first blank cell in column A | Excel Worksheet Functions | |||
Threaded Mode
