Countdiff with more criteria
"T. Valko" wrote...
....
Morefunc is one of the better add-ins available so don't let Bernd try to
convince you otherwise.
Definitely.
Cust (customer) refers to Sheet1!$A$2:$A$11
Eng (engineer) refers to Sheet1!$B$2:$B$11
Dates refers to Sheet1!$C$2:$C$11
I'm assuming the dates are all within the same year so we're only going to
test the dates for the month.
E2:E3 are the 1st of the month dates 1/11/2009, 1/12/2009
F1:G1 = JP, Bill
If there would be multiple result formulas, it may be better to define
a 4th name BIN referring to the formula =ROW(Cust)-MIN(ROW(Cust))
(omission of +1 intentional). The you could use formulas like
=COUNT(1/FREQUENCY(MATCH(Cust,Cust,0)*(Eng=F$1)*(MONTH(Date s)=MONTH
($E2)),Bin))-1
which doesn't have to be entered as an array formula [because it
doesn't call IF, and FREQUENCY always returns an array, so its results
are handled like array constants].
|