Matching two Columns using a Checkbox

Hammermill21

Hello!

So I need to check two columns for matching names and then check if another column has two different answers and check a box.

I want to check a box if the names and date matches:

I've tried a few times but it's not working for me.

Any ideas?

THANK YOU!

Paul Newcome

To check the box if the name and date match:

=IF(COUNTIFS(Name:Name, Name@row, Date:Date, Date@row) > 1, 1)

Paul Newcome

To check the box if the name and date match:

=IF(COUNTIFS(Name:Name, Name@row, Date:Date, Date@row) > 1, 1)

Dale Murphy

@Hammermill21 To clarify, are you checking columns or rows? From your example it looks like you are looking in subsequent rows for a matching entry in an earlier row? Otherwise I don't understand which of the columns (in your screenshot) are supposed to match.

Dale