Future in Hands club

Hi Frnds,

I am using Advanced filter in VBA code generally with Advanced filter we can filtered the data on some given criteria range but i wish to see data of that particular criteria range unchecked means does not equals to that range. 

Except that range data should be filtered there only for those criteria data will not show in raw dump.

Please find the attached sheet and suggest the correct way to resolved it.

Thanks,
Amit Sharma

Use Power Query