Need A way to filter out a specific value

[DRW2011]

I have a data set. I need to find a way to remove the "Y" result from this formula when the User is the same

Please Login or Register  to view this content.

A B C
Account Date User
1234567899 05/13/2017 123456
1234567899 05/14/2017 123456
1234567899 05/14/2017 123455
5555555555 05/15/2017 123870
4444444444 05/16/2017 130007

any ideas?

[Sam Capricci]

do you mean this?
=IF(COUNTIFS(A$2:A2,A2,C$2:C2,">="&C2-7,C$2:C2,"<="&C2+7)=2,"","N")

[DRW2011]

I put the wrong formula, my mistake.

Please Login or Register  to view this content.

I'd need a condition to account for column C

[Sam Capricci]

this?
=IF(COUNTIFS(A$2:A2,A2,B$2:B2,">="&B2-7,B$2:B2,"<="&B2+7,$C$2:C2,C2)=2,"Y","N")
or this without the "y"?
=IF(COUNTIFS(A$2:A2,A2,B$2:B2,">="&B2-7,B$2:B2,"<="&B2+7,$C$2:C2,C2)=2,"","N")

[DRW2011]

The blank doesn't work because it doesn't return repeat values
and the one with "y" doesn't account for the user being the same

[Sam Capricci]

I tested it out with repeating your values from your snapshot and it worked fine accounting for duplicate users.
if it isn't working for you please post an actual sample (desensitized) with a sufficient sample AND the results you expect.
I altered this one a little to account for where you have 3 or more values in the list that are dups but beyond that I cannot tell from your posts how it is that it isn't working.
=IF(COUNTIFS(A$2:A2,A2,B$2:B2,">="&B2-7,B$2:B2,"<="&B2+7,$C$2:C2,C2)>=2,"Y","N")

[DRW2011]

used the fomula in column D

Account Date User 7day_Check 1234567890 01/01/2018 123456 N 1234567890 01/09/2018 123456 N 1234567890 01/02/2018 123456 Y 1234567891 01/01/2018 123456 N 1234567892 01/02/2018 123457 N 1234567893 01/03/2018 123458 N 1234567894 01/04/2018 123459 N

This Yes I want to be blank. I do not want a User to be able to draw a "Y" with the same User in this field

if you need it in a workbook i can, just not near a computer now.