• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MS Excel: Subtract one list from another?

C

clickynext

Platinum Member
Hi,

I have two lists of names, let's call them A and B. Each list is a single column of values. A has all the names that B has, and some more. I want to take all the names that are in B out of A, so that A only ends up with names which are not in B. Anyone know how to do that? Thanks.
 
Set up a column C with the formula:

=IF(ISBLANK(A1), IF(ISNA(MATCH(A1,B$1:B$??,0),A1,""), "")

Replace ?? with in the number of names in column B, and copy this formula down column C for at least as many rows as are names in column A.

If you want the names in column C grouped together, do a sort on columns A through C using column C as the first key.

Good luck!
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top