Removing duplicates in various categories in a column

[buhaj47]

At my work I have to use reports that show various numbers for various categories, e.g. countries. Sometimes there are more than one lines for each category, and I need to remove duplicates. The issue is the numbers start from the same numbers for each category, so I do not want to use the usual function to remove duplicates.

Here is an example list:

I would like Excel to remove duplicates separately from each country so that the result is:

What formula/function to use?

 

[liveinhope]

Try this formula in the first blank column (in this case looks like that will be C) =COUNTIFS($A$2:A2,A2,$B$2:B2,B2)

This tells you that (for example on row 2 that this is the 1st row that has country "AUT" and request "REQ001"
on row 3 this is the 2nd row that has country "AUT" and request "REQ001"

Then you can either delete the rows where result is more than 1 , or copy all the lines with result of 1 to a new sheet

COUNTRY	request	COUNT
AUT	REQ001	1
AUT	REQ001	2
AUT	REQ001	3
AUT	REQ002	1
ENG	REQ001	1
ENG	REQ001	2
ENG	REQ002	1
ENG	REQ002	2
ENG	REQ003	1
POL	REQ001	1
POL	REQ001	2
POL	REQ002	1
TAI	REQ001	1
TAI	REQ001	2
TAI	REQ002	1
TAI	REQ002	2

<tbody>
</tbody><colgroup><col span="2"><col></colgroup>