In the attached file, I like to compare the LIST in cell A against cell C and if there is a match, I want to take the number from COUNT column (cell D), copy into column B, and add them to get one total. What is the best way to accomplish this?
Howdy. What about near matches? I.e. in column A you have "A & T " (which has two spaces at the end, as well as spaces between characters) and in Column C you have "A&T " (one space at the end, and no spaces between characters).
This will affect your data integrity and results.
old, slow, and confused
but at least I'm inconsistent!