Duplicate Count

Angela G.

Is there a way to reference more than one column when checking for duplicates? I would like to count the duplicates from Column A if Column B has already performed work for the individuals in Column A. Additionally, I would like to only count the duplicates between a certain timeframe (e.g. 10/1/24 - 10/31/24).

Paul Newcome

You would use an IF(COUNTIFS(……………….) > 1, 1) to flag the duplicates. I wouldn't be able to help with the inside of the COUNTIFS without some screenshots for context though.