Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find minimum value in column.
I wish to create a formula for cell AL12 to determine the minimum value found
in column F with the index of the current row and proceeding down the column the number of rows of the number in cell AK12(74). Thus looking for the minimum value in f12:f88. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find minimum value in column.
Based on your description the actual range would be F12:F85.
Try this: =MIN(F12:INDEX(F12:F100,AK12)) Adjust for the actual end of your range. If AK12 is empty the formula will evaluate the entire range. -- Biff Microsoft Excel MVP "dlbeiler" wrote in message ... I wish to create a formula for cell AL12 to determine the minimum value found in column F with the index of the current row and proceeding down the column the number of rows of the number in cell AK12(74). Thus looking for the minimum value in f12:f88. Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find minimum value in column.
Thank you again for all of your help. Everything works and the project is
complete. "T. Valko" wrote: Based on your description the actual range would be F12:F85. Try this: =MIN(F12:INDEX(F12:F100,AK12)) Adjust for the actual end of your range. If AK12 is empty the formula will evaluate the entire range. -- Biff Microsoft Excel MVP "dlbeiler" wrote in message ... I wish to create a formula for cell AL12 to determine the minimum value found in column F with the index of the current row and proceeding down the column the number of rows of the number in cell AK12(74). Thus looking for the minimum value in f12:f88. Thank you. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find minimum value in column.
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "dlbeiler" wrote in message ... Thank you again for all of your help. Everything works and the project is complete. "T. Valko" wrote: Based on your description the actual range would be F12:F85. Try this: =MIN(F12:INDEX(F12:F100,AK12)) Adjust for the actual end of your range. If AK12 is empty the formula will evaluate the entire range. -- Biff Microsoft Excel MVP "dlbeiler" wrote in message ... I wish to create a formula for cell AL12 to determine the minimum value found in column F with the index of the current row and proceeding down the column the number of rows of the number in cell AK12(74). Thus looking for the minimum value in f12:f88. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find the cell reference that contains the minimum or maximum | Excel Worksheet Functions | |||
Minimum qualifiers to Find (VBA) the actual last used Row, Column | Excel Discussion (Misc queries) | |||
Find minimum value greater than a particular value | Excel Worksheet Functions | |||
How do I find the minimum NONBLANK value in a sequence of cells? | New Users to Excel | |||
How to find the minimum value in a database with multiple values . | Excel Discussion (Misc queries) |