When I am looking for similar list errors, what I do is write an equation in a third column that compares the first two, =IF(A1<>B1,"?",""), and copy it down the length of the list. I'v e been doing it that way for years so if there is a better way i would be interested in hearing about it.
|