Kwnstantinos_M
New Member
- Joined
- Jun 12, 2018
- Messages
- 24
Hi guys..
I have the following 3 columns in my excel sheet. The dates in column A (DateTime) are in the same format as column N(DateTime2).
<tbody>
</tbody>
The data are a lot, so I can't check it one by one. I tried to use match command in order to identify which date from column N(DateTime2) exist in column A(DateTime). I used the following command:
=MATCH(N2;$A$2:$A$5849;0)
I used autofill and as a result I got only first value as a number (which means that it exists), and the rest as N/A ..which is wrong. As you can see the value 1/1/16 3:00 exist in both columns.
I tried then to use the function VLOOKUP and I wrote the following command:
=VLOOKUP(N2;$A$2:$A$5849;1;FALSE)
I got the same outcome.. I checked one random value (1/1/16 3:00) to check if the two cells with the same value are equal using the command : =A3=N5 and I got TRUE ..which means that the two cells are matching.
What do you think? What is the problem?
Thank you in advance
****** id="cke_pastebin" style="position: absolute; top: 216px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">Wh
<tbody>
</tbody></body>
I have the following 3 columns in my excel sheet. The dates in column A (DateTime) are in the same format as column N(DateTime2).
DateTime (column A) | DateTime2 (column N) | Match | VLOOKUP | ||
<colgroup><col></colgroup><tbody> </tbody> | 1/1/16 0:00 | 1 | 42370 | ||
<tbody> </tbody> | 1/1/16 1:00 | N/A | N/A | ||
1/1/16 6:00 | 1/1/16 2:00 | N/A | N/A | ||
1/1/16 9:00 | 1/1/16 3:00 | N/A | N/A | ||
1/1/16 12:00 | 1/1/16 4:00 | N/A | N/A | ||
1/1/16 15:00 | 1/1/16 5:00 | N/A | N/A | ||
1/1/16 18:00 | 1/1/16 6:00 | N/A | N/A | ||
1/1/16 21:00 | 1/1/16 7:00 | N/A | N/A | ||
1/1/16 00:00 | 1/1/16 8:00 | N/A | N/A |
<tbody>
</tbody>
The data are a lot, so I can't check it one by one. I tried to use match command in order to identify which date from column N(DateTime2) exist in column A(DateTime). I used the following command:
=MATCH(N2;$A$2:$A$5849;0)
I used autofill and as a result I got only first value as a number (which means that it exists), and the rest as N/A ..which is wrong. As you can see the value 1/1/16 3:00 exist in both columns.
I tried then to use the function VLOOKUP and I wrote the following command:
=VLOOKUP(N2;$A$2:$A$5849;1;FALSE)
I got the same outcome.. I checked one random value (1/1/16 3:00) to check if the two cells with the same value are equal using the command : =A3=N5 and I got TRUE ..which means that the two cells are matching.
What do you think? What is the problem?
Thank you in advance
****** id="cke_pastebin" style="position: absolute; top: 216px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">Wh
N/A |
<tbody>
</tbody>