J
JC
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$2003=D450)*(E$4:E$2003=E450))>1,"Dup",""))
now my issue is HOW DO i remove data in non blank cells in range D4:Q2300.
macro?
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$2003=D450)*(E$4:E$2003=E450))>1,"Dup",""))
now my issue is HOW DO i remove data in non blank cells in range D4:Q2300.
macro?