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?.

2016/07/05	22:00:00	10724	10751
2016/07/05	22:30:00	10737	10755
2016/07/05	23:00:00	10666	10716
2016/07/05	23:30:00	10683	10726
2016/07/06	00:00:00	10710	10746

<tbody>
</tbody>

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