help new question how to formula needed

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:D$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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top