I have data in 2 columns D & E .
i CREATED A VLOOKUP WHICH Tells me if data e is not valid
with a blank value in column A for non list!E2:E3470 items , Column B tells
me if data in column d is duplicated

column A formula

=IF(ISNA(VLOOKUP(E435,List!$E$2:$F$3470,1,FALSE)), "",VLOOKUP(E435,List!$E$2:$F$3470,1,FALSE))

formula column B
=IF(D450="","",IF(SUM((D$4:D$2003=D450)*(E$4:E$200 3=E450))1,"Dup",""))

now my issue is HOW DO i remove data in non blank cells in range D4:Q2300.
macro?