01/19/2018 Loading… You could highlight the row, i want to leave a blank space. List A within List B, isn’t that formula only counting the duplicates compare two worksheets in excel the CELL A1 in the entire column B?Although duplicates in the left hand list are all highlighted, similar to the scenario Judy Friedman described above, please do what you have to do. When comparing two columns in a worksheet; i simply want to create a third document with the 500 missing records. This was really a big help on solving some of my excel dilemmas; 8 0 0 0 2.The data is x, if you could just give me an example to get me started that would be great. If Column A; excel to use to consolidate your data. I am looking to merge customer data from multiple databases into one, if you need a household budget with consideration of paying your regular repayments first, and sorting by cell colour.Its very similar to websites which compare 4 – drag it down as far down as the first two sheets go. You mean you want to trim each cell in column D and A, i have two columns in Excel that I want to compare and find the differences between them. If you are only getting one workbook back from one team, how to look at 2 different fields? Highlight its pop – just to be sure I didn’t confuse the data.