find smallest time value per date per criteria

[young_86]

Hi,
I've got 2 column table. In column A I've got list of different names. In column B I've got date and time (yyyy-mm-ss hh:mm:ss). I need to write formula which tell me which of data value is the smalest one per name in every day. In need to write formula in column C which show me X when the time is the smalest one per name and per specific day, like you see below.
A B C
name1 2014-09-01 12:20:56
name1 2014-09-01 12:10:51 x
name1 2014-09-02 12:02:10 x
name1 2014-09-02 12:11:51
name2 2014-09-01 12:12:12
name2 2014-09-01 12:20:56
name2 2014-09-01 12:10:56
name2 2014-09-01 04:10:56 x
name2 2014-09-02 12:10:56
name2 2014-09-02 09:10:56 x

I try something with matching but without any positive result.
Thank you in advance for help.

[Tony Valko]

Try this array formula** entered in C2 and copied down:

=IF(B2=MIN(IF(A$2:A$11=A2,IF(INT(B$2:B$11)=INT(B2),B$2:B$11))),"x","")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[gak67]

Or this array formula in C2 and dragged down:

Please Login or Register  to view this content.

[young_86]

tahanks for help!!!

[Tony Valko]

You're welcome!