Hello!
At first a good news - there is no bad news!
While preparing the test file, I finally learnt how to use the MIN(IF())) array function with more then one condition, as indeed already suggested by MrProgram in
viewtopic.php?t=93608
However I'm curious to know other formulas to get the same. So I have uploaded the test file for simpler explanation.
Test file description
it contains two tabs:
1. In Year Report there is the data to be evaluated
2. in Plausibility Check there is the table with the desired statistical values
The Year Report
This shows which tasks I have absolved and how much time I needed for. It is used as monthly report to my employer (only columns E -> I) as PDF file.
a) In row 11 are written the range names for the respective columns, for each one the rows 17->808;
b) The col. Job 1 lists the name of the principal task, sometimes of the second one in col. Job 2.
c) The column
I shows the job names, often the first stop time, sometimes other information (not important here). All this data are now only as text, but they were originally got from other columns or rather other spreadsheets.
d) There are many hidden columns They are not important here, but I didn't eliminated them, because I am afraid, any formulas might lose references.
Plausibility Check table
I'd like to use it in order to reduce typing errors on input time data, just a plausibility check table. So I can manually check the report for the usual tasks quicker, before sending it. .
a) The col. "LS Job" shows the usual tasks (a sort of milk round) for which I need the duration values.
b) The values in the right part table should shows statistical values for the respective jobs inside given data range (between D4 and F4).
What I need in the Plausibility Check table:
As already written above, I found the solution for my case. But I find interesting, if there are other formulas to calculate:
a) the minimum time value in given data range;
b) the minimum time value in given data range for the respective jobs done on Monday, when every one need much more time for job explication.
I hope, I've given all necessary information about the test file and thank you very much for support.