min -problem

[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

 

[Frank Kabel]

Hi
try the following array formula (entered with
CTRL+SHIFT+ENTER):
=MIN(IF((A1:A100=DATE(2004,2,2))*(B1:B100=1376),C1:C100))

 

[zuapfly]

i'm sorry, the function seems to take the minimum value of that entir
row..

 

[JE McGimpsey]

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.