Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding the minimum in a selected number of rows of the same colum
Hello,
I want to find the minimum time in which a batch has been produced for each quarter of a year. I have tried different formulas (included arrays + Control/Shift/Enter) with unsatisfied results. Below is a simplified example for the year 2003. A B C D 1 Year Quarter Date Duration of batch 2 2003 Q1 01-02-03 13:45 3 02-02-03 12:45 4 10-03-03 9:54 5 2003 Q2 11-04-03 11:24 6 24-05-03 11:00 7 24-06-03 10:15 8 2003 Q3 14-07-03 11:15 9 14-07-03 10:45 10 02-08-03 16:30 11 2003 Q4 02-11-03 15:00 12 22-11-03 12:45 13 23-12-03 13:00 I hope this makes sense. Kind regards Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set number of rows equal in mutiple columns | Excel Discussion (Misc queries) | |||
maximum number of rows that can be coppied to clipboard | New Users to Excel | |||
Finding minimum value across selected rows of an array | Excel Worksheet Functions | |||
increasing the number of rows of a worksheet beyond 65536? | Excel Discussion (Misc queries) | |||
Display selected rows from one worksheet to another | Excel Worksheet Functions |