| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Finding minimum value across selected rows of an array
I have a table of data which has time values in column B and numerical values
in column C. I am using the Sumproduct function to find the average value of C using only data when the time is between 730 and 930 with great success. The problem is I also need to find the minimum and maximum values during these same times. I tried using Max(if( with ctrl-shft-enter (though I'm not sure if this is a proper formula) with no luck. Can someone please help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | 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 Master Sheet | New Users to Excel | |||
| Display selected rows from one worksheet to another | Excel Worksheet Functions | |||
Threaded Mode
