One other interp ..

Assuming source names in cols DO, DQ are running in row2 down

Place in DR2:
=IF(COUNTA(DO2,DQ2)<2,"",TRIM(DO2)=TRIM(DQ2))
Copy down to the last row of data in cols DO/DQ. Col DR will return TRUE if
the names match on the same row (using TRIM will disregard any extraneous
space/s), FALSE if they don't match & blank if data is incomplete for
matching (either both DO/DQ blank, or one of the cols is blank). You could
then easily apply autofilter on col DR (via DataFilterAutofilter), and
filter out TRUE cases from the autofilter droplist in DR1.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Toria" wrote:
Hello,

I have two columns of names, DO and DQ. I need to know when there's a match
without going row by row and maunally eyeballing it. I've spent all morning
trying to figure out. Any help is much appreciated.

Thank you.