Find Earliest Time For Each Serial Number

Hi

You can do this with function. Have a look at the attached file and see how it goes.

rylo

It's not working so well. I tried changing the range to fit my data and I get #DIV/0 error or a blank cell. This is what I changed the formula to.

=IF(ROW()-1>SUM(1/COUNTIF($S$2:$S$4239,$S$2:$S$4239)),"",INDEX(S:S,SMALL(IF(ISNUMBER(MATCH(ROW($S$2:$S$4239),MATCH($S$2:$S$4239,$S$2:$S$4239,0),0)),ROW($S$2:$S$4239),""),ROW()-1)))

The only things I changed from what was posted was all of the column A to row S, row 8 to 4239, and INDEX(A:A, to INDEX(S:S,.

I appreciate the help and I'll keep trying while I wait to hear back.

Here's a slightly different approach....

Put this formula in U2

=IF(S2<>S3,MIN(IF(S$2:S2=S2,T$2:T2)),"")

confirm with CTRL+SHIFT+ENTER, format as time and copy formula all the way down the column.

Now filter this column on non-blanks and hide column T

Hi

Can you please put up a sample file with some representative data, and some results you would expect to get from that data.


rylo