| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formula that returns the number at the bottom of a list
Hi there,
I have a column that lists numbers for rows 3 to 100. What I'm wondering is there a formula that will give me the current "bottom" number? ex. ColB 2 3 5 12 14 14 9 0 0 1 The formula would give 1, as it is the bottom number in the list. Now if I added a 3 below the 1, the formula would then give 3, as it is the new bottom number in the column. Thanks! Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add rows to top of list instead of bottom | Excel Worksheet Functions | |||
| Filtering out top & bottom 2.5% in a list | Excel Worksheet Functions | |||
| How to remove the top & bottom 10% from a list? | Excel Discussion (Misc queries) | |||
| "IF" formula returns zero or other incorrect number | Excel Worksheet Functions | |||
| Identifying bottom of list | Excel Worksheet Functions | |||
Threaded Mode
