I think I understand. You only want to return a "1" for the second duplicate row (not both rows that are duplicates), correct?

If so, one way you can do this is to leverage a unique identifier for each row. If you don't have one already, you can use auto number to create a column of unique ROWIDs. Then, instead of COUNTIFS, you can use INDEX()/COLLECT() like this:

=IF([ROWID]@row <> INDEX(COLLECT([ROWID]:[ROWID], [Conference Room]:[Conference Room], [Conference Room]@row, [From:]:[From:], [From:]@row, [To:]:[To:], [To:]@row, [Time:]:[Time:], [Time:]@row),1), 1, 0)

The COLLECT() function is gathering all of the ROWIDs that meet the set of criteria.

The INDEX() Function returns the first ROWID from the list you've just collected.

The IF() function only sets it to 1 if the current ROWID isn't the same as the 1st ROWID in the collected list.

In the end, you will get a "1" on all of the duplicate rows but the first duplicate. You'll get 0's everywhere else.

Hopefully I didn't miss a comma or parentheses in my formula.

Good luck!

Hi @malanto,

Since ROWID is always ascending, the most recent will have the largest value. So Just swap the MAX() function for the INDEX() function. In your case:

=IF([ROWID]@row <> MAX(COLLECT([ROWID]:[ROWID], [Task Number]:[Task Number], [Task Number]@row, [Task Desc]:[Task Desc], [Task Desc]@row), 1, 0)

Hope that helps,

Be well