Kwnstantinos_M
New Member
- Joined
- Jun 12, 2018
- Messages
- 24
Hello,
I have two columns of dates as shown in the below table:
<tbody>
</tbody>
The first column contain approximately 11,900 rows of dates and the second one 5900. I want to use a function in order to identify which exact dates and hours exist in both columns. As I have it in mind, the best way is to have a third column in which I will recieve a "yes" if it exists and "no" if it doesn't.. I used =MATCH(N2;$A$2:$A$5849;0) but the outcome wasn't right.. Do you have any ideas?
I have two columns of dates as shown in the below table:
5/1/2016 01:00 | 5/1/2016 01:00 | yes |
5/1/2016 02:00 | 5/1/2016 04:00 | yes |
5/1/2016 02:00 | 6/1/2016 05:00 | yes |
5/1/2016 03:00 | 7/2/2016 10:00 | no |
5/1/2016 04:00 | 8/2/2016 05:00 | yes |
5/1/2016 05:00 | 9/3/2016 05:00 | no |
5/1/2016 06:00 | 10/5/2016 07:00 | yes |
5/1/2016 07:00 | 12/5/2016 05:00 | yes |
5/1/2016 08:00 | 15/5/2016 18:00 | no |
5/1/2016 09:00 | 18/6/2016 22:00 | no |
<tbody>
</tbody>
The first column contain approximately 11,900 rows of dates and the second one 5900. I want to use a function in order to identify which exact dates and hours exist in both columns. As I have it in mind, the best way is to have a third column in which I will recieve a "yes" if it exists and "no" if it doesn't.. I used =MATCH(N2;$A$2:$A$5849;0) but the outcome wasn't right.. Do you have any ideas?
Last edited: