Checking for duplication across two fields
Have used the formula posted to this forum to identify duplicates in a single column using [IF(COUNTIF())} formula. I have a site/dept type issue split across two columns and need to identify when the same site/dept combination has been used in another record. I have tried using AND in the COUNTIF() but just can't get it to work. Should that logic work and it is just me typing incorrectly? Anyone got a different neat solution?