| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a formula that returns the number at the bottom of a list
make that =LOOKUP(1000000000,A3:a100)
"mpenkala" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a formula that returns the number at the bottom of a list
say your data is in column A
=vlookup(1000000000000,A3:a100) "mpenkala" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a formula that returns the number at the bottom of a list
On Mon, 4 Feb 2008 12:14:01 -0800, mpenkala
wrote: 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 =LOOKUP(1E+307,B:B) --ron |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a formula that returns the number at the bottom of a list
On Mon, 04 Feb 2008 15:40:56 -0500, Ron Rosenfeld
wrote: =LOOKUP(1E+307,B:B) Since you specified rows 3:100, you can change the above to, for example: =LOOKUP(1E+307,B3:B100) --ron |
| Reply |
| 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 | |||
Linear Mode
