Hello – I am trying to check data across just 2 Tabs to see if the dates match but the problem I am running into is the report is the same but the entries are not lining up so I am getting all True results where they might not be as I’ve tested a few entries with different dates and the result does not change. There are 2 entries that are required to match, name and floor #, and I’ve been using: If(OR(CountIF(Criteria1), (Criteria2)),IF(CountIF(Matching Criteria, True, False), Error). Any help would be appreciated, thank you

​Hello – I am trying to check data across just 2 Tabs to see if the dates match but the problem I am running into is the report is the same but the entries are not lining up so I am getting all True results where they might not be as I’ve tested a few entries with different dates and the result does not change. There are 2 entries that are required to match, name and floor #, and I’ve been using: If(OR(CountIF(Criteria1), (Criteria2)),IF(CountIF(Matching Criteria, True, False), Error). Any help would be appreciated, thank you    Read More

​