Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |