Vincent518
New Member
- Joined
- Aug 15, 2022
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
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?