Removing duplicates with multiple columns

[Tabitha5]

I have a dataset with two columns that I need to remove certain duplicates from. The first is a list of numbers, the second is text strings. For example

5 | Apple
3 | Banana
5 | Apricot
5 | Apple
2 | Banana
3 | Apricot

I need to remove only the duplicate numbers that also have the same text string. So in the above I'd need to take out one of the 5|Apple rows, but nothing else. I can remove duplicates from a single column no problem but am running into difficulty figuring it out for two columns, so appreciate if someone could point me in the right direction. I've been trying with the custom filter function.

Thanks

[FDibbins]

Hi and welcome to the forum

Assuming you want to keep 1 of the duplicate rows, try 1 of these...
for 2007...
=COUNTIFS($A$1:A4,A4,$B$1:B4,B4)
for 2003 (as your profile says)...
=SUMPRODUCT(($A$1:A4=A4)*($B$1:B4=B4))

Then apply filters, uncheck "1", and delete what remains

[Tabitha5]

Thanks I can't try it out at the moment but I'm sure that will work, so I'll make this as solved. Cheers.

[FDibbins]

you are welcome and thanks for the feedback... shout if you need more help

(well, actually, dont shout, I probably wont heard you lol)