min -problem

  • Thread starter Thread starter zuapfly
  • Start date Start date
Z

zuapfly

hi,

i've got a problem with a formula that i think u wizzkids can solve,

i want to have the minimum hour of person 1376 on date 02/02
suppose the illustration below shows column A,B,C and line 1,2,3,4



02/02 1376 15:05
02/02 1376 14:05
02/02 1405
03/02 1376


th
 
Hi
try the following array formula (entered with
CTRL+SHIFT+ENTER):
=MIN(IF((A1:A100=DATE(2004,2,2))*(B1:B100=1376),C1:C100))
 
Did you array-enter the formula as Frank indicated? If you did, it will
only return values for which the employee number is 1376 and the date is
2/2/04.
 
Back
Top