Start Time lookup

[PHIL.Pearce84]

Hi,

I have a rather large sheet containing vehicle tracking information, I need to identify the first trip for each day for each driver. I have the formula below, which seems to work over a short range, however when expanded to incorporate all entries I get a completely different value?

Any help would be greatly appreciated.


=MIN(IF(AND($C$2:$C$20964=Q1,$D$2:$D$20964=$P$2),$G$2:$G$20964,""))

Q1=Persons Name
P2=Date

 

[etaf]

try

=MIN(IF($C$2:$C$20964=Q1,IF($D$2:$D$20964=P2,$G$2:$G$20964)))
and then use
Control + Shift + enter
to setup as an array formula and get {} around the formula
{=MIN(IF($C$2:$C$20964=Q1,IF($D$2:$D$20964=P2,$G$2:$G$20964)))}

g2 to G20964 must have values in and not be blank

 

[PHIL.Pearce84]

Amazing Thank you!

Do you mind explaining how the array solves the problem?

 

[etaf]

this may explain better for this specific MIN calc
https://exceljet.net/formula/minimum-if-multiple-criteria
but this is good site for tutorials
http://www.cpearson.com/excel/arrayformulas.aspx