| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function should I use
Say I have three columns with different numbers. These numbers may go up or
they may go down. I want to be able to choose a function and have it find the lowest number out of the three colums. Column 1 Column 2 Column 3 215 185 398 I want the function to choose the middle because it is the lowest. But next week the lowest might be in column 3. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What function should I use
Bonnie wrote:
Say I have three columns with different numbers. These numbers may go up or they may go down. I want to be able to choose a function and have it find the lowest number out of the three colums. Column 1 Column 2 Column 3 215 185 398 I want the function to choose the middle because it is the lowest. But next week the lowest might be in column 3. Look at "MIN worksheet function" in the help file. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What function should I use
hi
=Min(a1:a3) Mike "Bonnie" wrote: Say I have three columns with different numbers. These numbers may go up or they may go down. I want to be able to choose a function and have it find the lowest number out of the three colums. Column 1 Column 2 Column 3 215 185 398 I want the function to choose the middle because it is the lowest. But next week the lowest might be in column 3. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What function should I use
=SMALL(A1:C1,2)
On Jan 17, 1:39*am, Bonnie wrote: Say I have three columns with different numbers. These numbers may go up or they may go down. I want to be able to choose a function and have it find the lowest number out of the three colums. Column 1 * * *Column 2 * *Column 3 * *215 * * * * * * * 185 * * * * * *398 I want the function to choose the middle because it is the lowest. But next week the lowest might be in column 3. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What function should I use
Try this
=MIN(A1:C255) adjust range to your needs. HTH John "Bonnie" wrote in message ... Say I have three columns with different numbers. These numbers may go up or they may go down. I want to be able to choose a function and have it find the lowest number out of the three colums. Column 1 Column 2 Column 3 215 185 398 I want the function to choose the middle because it is the lowest. But next week the lowest might be in column 3. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Hybrid Mode
