I have successful Vlookup formulas and duplicate values between multiple
columns in a multipage spreadsheet. However, when I try to compare by
duplicate value a third set of 2 columns, Excel 2007 sees the entries as
unique while they are clearly duplicates. The only thing I see different in
this comparison over the other column comparisons is that I am using a
formula =LEFT(J3, SEARCH(" ",J3,SEARCH(" ",J3,1)+1)) in one of the columns.
Any suggestions?