| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Finding min,max in an array using selected rows from a table
I have a table which has time values in column B and numerical values in
column C. I am using the Sumproduct function with great success to calculate the average value of C for all entries where the time is greater than 730am and less than 930am. The problem is I need to find the minimum and maximum values of C using this same criteria. I tried using Min(if( with no success but I'm not sure if that is a correct use of the Min function. Can someone please help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding minimum value across selected rows of an array | Excel Worksheet Functions | |||
| Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
| Deselect one of many non-adjacent rows selected | Excel Discussion (Misc queries) | |||
| Adding rows to an array | Excel Worksheet Functions | |||
| Display selected rows from one worksheet to another | Excel Worksheet Functions | |||
Threaded Mode
