Multi Cell search row wise

[treeppm]

Hello brothers, I hope everyone doing well.

I've bunch of data like following. If suppose I want search particular date and time
How to search multiple cells in Excel?.

[TABLE="width: 500"]
<tbody>[TR]
[TD]2016/07/05[/TD]
[TD]22:00:00[/TD]
[TD]10724[/TD]
[TD]10751[/TD]
[/TR]
[TR]
[TD]2016/07/05[/TD]
[TD]22:30:00[/TD]
[TD]10737[/TD]
[TD]10755[/TD]
[/TR]
[TR]
[TD]2016/07/05[/TD]
[TD]23:00:00[/TD]
[TD]10666[/TD]
[TD]10716[/TD]
[/TR]
[TR]
[TD]2016/07/05[/TD]
[TD]23:30:00[/TD]
[TD]10683[/TD]
[TD]10726[/TD]
[/TR]
[TR]
[TD]2016/07/06[/TD]
[TD]00:00:00[/TD]
[TD]10710[/TD]
[TD]10746[/TD]
[/TR]
</tbody>[/TABLE]

like this kind of data's I've in excel

If I want go 2016/08/06 at the time 12:30:00 How to search and find that in Excel?

Kind Regards

 

[Yongle]

One way is to use a helper column

With
- search date in G1
- earch time in H1
- data in columns A:D starting in row2

Paste this formula in E2 and copy down
=IF(AND(A2=$G$1,B2=$H$1),"Match","")

Now either search for "Match" or use Data Filter , filter on "Match" in column E

OR formula to check by addition of date and time
=IF(ROUND(A2+B2,5)=ROUND($G$1+$H$1,5),"Match","")

 

[Aladin Akyurek]

Could you give an example what you are looking for using the sample you posted?

 

[treeppm]

I Got another Idea friends. Thank you so much for trying to solve my problems. It's been great to be here. live happy friends.

Best Regards

 

[Yongle]

I Got another Idea friends

@treeppm
Please do not keep your "idea" secret
Reply to the thread and tells us what you did so that others may benefit