Compring Dates?
 

HELP!
I have a set of dates I want to compare and return the data in data 1 if all
match, or 2 and 3 are blank, but flag if they mismatch as in the first
column. Is this possible?????

Data 1 01/04/1981 07/10/2024 07/10/2024 01/10/1982
Data 2 02/04/1982 07/10/2024
Data 3 01/04/1981 07/10/2024 01/10/1982

Match? No - flag Yes - data 1 Yes - data 1 Yes - data 1

Many thanks in advance (P.S. - It's 2007)
Scoz

Compring Dates?
 

One idea ..
Assuming dates data as posted is within B1:E3
(dates are presumed real dates, which are just numbers)
In say, B5:
=IF(SUMPRODUCT(--(B1:B3<""),1/COUNTIF(B1:B3,B1:B3&""))1,"X","")
Copy B5 across to E5 to flag it as: X
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"scoz" wrote:
I have a set of dates I want to compare and return the data in data 1 if all
match, or 2 and 3 are blank, but flag if they mismatch as in the first
column. Is this possible?????

Data 1 01/04/1981 07/10/2024 07/10/2024 01/10/1982
Data 2 02/04/1982 07/10/2024
Data 3 01/04/1981 07/10/2024 01/10/1982

Match? No - flag Yes - data 1 Yes - data 1 Yes - data 1

Many thanks in advance (P.S. - It's 2007)
Scoz

Compring Dates?
 

Since you indicated that you want to return the data in row1 if its unflagged,
Adjust it in B5 to:
=IF(SUMPRODUCT(--(B1:B3<""),1/COUNTIF(B1:B3,B1:B3&""))1,"X",B1)
Copy across as before
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

Compring Dates?
 

Many thanks Max, looks like you cracked it, I've forwarded to what I hope is
a very happy chappy.
Scoz

"Max" wrote:

Since you indicated that you want to return the data in row1 if its unflagged,
Adjust it in B5 to:
=IF(SUMPRODUCT(--(B1:B3<""),1/COUNTIF(B1:B3,B1:B3&""))1,"X",B1)
Copy across as before
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

Compring Dates?
 

Welcome. Pl mark all responses which help by pressing the YES buttons (like
the ones below).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"scoz" wrote:
Many thanks Max, looks like you cracked it, I've forwarded to what I hope is
a very happy chappy.
Scoz