Finding duplicates

[Tortoise90]

Hi All,

Excel newbie here. I have a query about finding duplicates.

I have a large section of data where there is the ID, country, date and usage.

I am trying to figure out a way that I can check that the ID doesn't have a duplicate value on the same date.

Attached an the excel file.

Thanks!

[Phuocam]

Try this:

=IF(COUNTIFS($A$2:$A$3800,A2,$B$2:$B$3800,B2,$C$2:$C$3800,C2)>1,"Duplicates","No")

[Brian Itotia]

hi There
i have returned your file with a nested formula on column G that
references down both columns youre checking and returns duplicate if a record has a duplicate.

ps. Mark as solved if solved and please rate me up if my help was useful.

[Tortoise90]

Thanks guys - super helpful