This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi. I'm trying to compare two columns of data to look for MISSING data. I have two columns with over a thousand names each column. Most names in column A are also in column B. What I'm trying to determine is the names in column A that ARE NOT in column B. Is there a formula for this? Thanks
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
In [C2] put =COUNTIF(B:B, A2) then fill down to the extent of values in column A. Filter for 0 in column C and the visible values in column A will be the ones that do not exist in column B.
Thanks, that worked!