How to find Min date and time with respective name

[Vikas_Salvi]

How to find Min date and time with respective name

 

[ETAF]

=MINIFS(B:B,A:A,A2)

what version of excel do you have ?

or a pivot table

 

[Vikas_Salvi]

=MINIFS(B:B,A:A,A2)

this formula is not in working MS office 2010, is there any alternate formula the same

 

[ETAF]

no it wont
=MIN(IF(A:A=A2,B:B,""))
us control+shift+enter to enter as an array formula
it will then look like
{=MIN(IF(A:A=A2,B:B,""))}
with curly brackets

probably not a good idea to reference complete cells
so set the range
=MIN(IF($A2:$A$100000=A2,B$2:B$100000,""))