CODEWITHSUNDEEP
excel
user3242172
user3242172

Reputation: 1

Flagging duplicates in Excel based on Date and Email address

I am needing a way to look at a list of survey responses in an Excel document and remove duplicates following this rule: Up to three responses are allowed per day, per email address.

I have a spreadsheet that has the date in the first column and the email address in the second column.

I need to change the formatting on any rows that have more than three duplicate email addresses on the same date.

Thanks in advance for the help

Edit: I'd prefer to do this inside the Excel document, but could also tackle it in C# or PHP if there is not a solution for this in Excel

Upvotes: 0

Views: 77

Answers (1)

B-Rell
B-Rell

Reputation: 636

I think what you are wanting is fairly simple, try this:

enter image description here

Then you can easily identify the offending posts by adding conditional formatting:

enter image description here

Hope this helps!

Upvotes: 1

Related Questions