This does help. The only thing is that I have two list and one list have 450
more students. Will this only match the first 10 columns that have identical
information? I need a formula that will place a blank row or a row where it
doesn't match.

"garzar" wrote:

Comparing columns D and F, If the data doesn't match, I need a blank inserted
where the columns don't match. How can I achieve this?