VBA to filter records

[Negi1984]

Hi All,

I have 3 columns in a table Name, RESOURCE STATUS and ASSIGNMENT STATUS.
I want to create a macro which will filter if below mentioned condition not satisfy.

Example Data table :-

Name	DOMAIN	RESOURCE STATUS	ASSIGNMENT STATUS	Remarks
A	Delhi	ENGAGED/APPROVED		ignore case from macro
B	Delhi	ENGAGED/APPROVED		need to filter using macro
B	Mumbai	LEFT PROJECT		need to filter using macro
C	Delhi	LEFT PROJECT	OLD-INACTIVE	ignore case from macro
C	Mumbai	ENGAGED/APPROVED		ignore case from macro
C	Kolkata	ENGAGED/APPROVED		ignore case from macro
D	Mumbai	LEFT PROJECT	OLD-INACTIVE	need to filter using macro
D	Kolkata	LEFT PROJECT		need to filter using macro
D	Kolkata	LEFT PROJECT		need to filter using macro

1) Case 1 Now in above table Name "B" is repeated twice and status here is "ENGAGED/APPROVED" & "LEFT PROJECT" both. so in that case "OLD-INACTIVE" should be mentioned in front of "LEFT PROJECT" and we need to create a macro which can identify this case.
2) Case 2 name "D" is repeated 3 times in list and "Left project" status only repeated 3 times. So "Old-inactive should be mentioned against first 2 repetition. we need to create a macro which can identify this case.

Can anybody suggest me any macro to achieve this goal ?