From above Title you may think its easy. But for me it is not. I am struggling in this. It will be much appreciated if anyone solve this.

I have attahed my sample data.I need a MACRO

In this , I need a code to check the 'E' column and pop up should be displayed with the number of Duplicate values (If any duplicates found)
Eg., Duplicate values found = 4

Also One pop up should take the Status column - 'G' and should return the number of values depend on the status. It should return the below mentioned details in same pop up(Along with duplicate values).
Eg., Closed = 5
Open = 5
Waiting =3
Reopen = 57
Assigned = 65

It depends. But the value of status (eg.,Assigned, Reopen) may varry.The status may be any thing.

Please help me to sort this thing SampleExcel.xlsx