Jecki
Reputation: 802
MS Excel: Difference between 2 columns.?
I've two columns A and B that contain lists of usernames,
column B has some usernames not in column A How can I find them and store them in column C?
Upvotes: 0
Views: 5775
Answers (1)
Muhammad Umar
Reputation: 3781
Use this formula for cell C1:
=IF(ISERROR(MATCH(B1,$A$1:$A$5,0)),B1,"")
Drag it down to the last row of the list in column B.
Upvotes: 2
Related Questions
- Excel spreadsheet: how to find the difference between two sets of columns in the same row
- Comparing two columns and printing out the difference?
- Find the difference between two cells of text in Excel
- Compare two columns in excel and find the differences with VBA
- Excel: Store the difference of two columns in another column
- Find the difference between two text fields in excel
- Find the difference between two cells
- Difference between two columns with only sign
- How do I compare two columns in excel
- How do I compare two columns in Excel?