Comapare two columns containing date and time
Closed
Hello,
I would like to comapare two columns containing date and time data to is if the match. If the don't, i would like to return a value i.e. "1" to the same row in another colum for filtering later on.
Thanks in advance!
Kind regards
Anders Nilsson
I would like to comapare two columns containing date and time data to is if the match. If the don't, i would like to return a value i.e. "1" to the same row in another colum for filtering later on.
Thanks in advance!
Kind regards
Anders Nilsson
Related:
- Comapare two columns containing date and time
- Popcorn time download - Download - Movies, series and TV
- How to change whatsapp date and time - Guide
- Ocarina of time rom - Download - Action and adventure
- Display two columns in data validation list but return only one - Guide
- Facebook id verification time - Guide
1 response
Here is an example of what I'm trying to do:
A B C
06/15/2009 11:40 PM 06/15/2009 11:40 PM
06/15/2009 11:50 PM 06/16/2009 12:00 AM
06/16/2009 12:00 AM 06/16/2009 12:10 AM
If the date i time in column A dont match the date and time i column B i would like to have a value of some kind returned to column C:
A B C
06/15/2009 11:40 PM 06/15/2009 11:40 PM
06/15/2009 11:50 PM 06/16/2009 12:00 AM 1
06/16/2009 12:00 AM 06/16/2009 12:10 AM 1
A B C
06/15/2009 11:40 PM 06/15/2009 11:40 PM
06/15/2009 11:50 PM 06/16/2009 12:00 AM
06/16/2009 12:00 AM 06/16/2009 12:10 AM
If the date i time in column A dont match the date and time i column B i would like to have a value of some kind returned to column C:
A B C
06/15/2009 11:40 PM 06/15/2009 11:40 PM
06/15/2009 11:50 PM 06/16/2009 12:00 AM 1
06/16/2009 12:00 AM 06/16/2009 12:10 AM 1