Excel - Match Data if Excel 1 is between Date and Time of Excel 2

[Vincent518]

I am having problem matching 2 of these data. This data shows Admission and Payment in separate excel sheet. My purpose is to search out for those admission without payment.

The date and time at "Payment Date" if payment was made, will be always in between the date and time in "Admission Data".

I wish to combine the both by matching if data in "Payment data" the time is between the Entry and Exit time in "Admission Data", the data from column A to column C of the "Payment Data" will be copied and aligned to "Admission Data" column E to column G respectively. With this, I will then be able to see which row at the "Admission Data" are without payment.

Conditional formatting to search duplicate value of both column A is not feasible since one person can enter and exit multiple times within a day.

I am processing about over a ten over thousand of row for both Admission and Payment hence the need to use formula or conditional formatting or other methods to achieve my purpose. Is there anyone can help me with this?

 

[SanjayGMusafir]

Sorry I am quite an amateur when it comes to excel. I do know what is XL2BB by the way

See this link

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

 

[Vincent518]

Sorry I am quite an amateur when it comes to excel. I do know what is XL2BB by the way

I do not**

 

[arthurbr]

Different Sheets or different Excel file between the two doesn't matter right?

If you say so