Time Stamp

[Basavaraj K H]

Dear Team

I need Start Time (Cell F3)& End time (cell G3) of TSM Mobile No. as per date wise from "Details" Sheet refer column B C & D respectively.

Kindly Refer attached file.


Thanks

Thanks
Basavaraj K H

 

[Deepak]

if data is sorted then..

CSE
F3=INDEX(Details!$C$1:$C$10154,MATCH(1,(Details!$B$1:$B$10154=E$1)*(Details!$D$1:$D$10154=$C3),0))


G3=LOOKUP(2,1/((Details!$B$1:$B$10154=E$1)*(Details!$D$1:$D$10154=$C3)),Details!$C$1:$C$10154)

 

[Deepak]

Another would be.

both are CSE..

=MIN(IF((Details!$B$1:$B$10154=E$1)*(Details!$D$1:$D$10154=$C3),Details!$C$1:$C$10154))

=MAX(IF((Details!$B$1:$B$10154=E$1)*(Details!$D$1:$D$10154=$C3),Details!$C$1:$C$10154))