Hello Experts,
I need help in comparing two columns.
In column A, i have a listing of equipments which consist of 311 equipment.
In column B, i have another listing of equipments which consist of 450 equipment.
I need to compare column A to column B and determine what is missing in column A to equal column B.
What can be the easiest approach to this? Hope this is not confusing!
Thank you!
Maybe you could attach a sample?
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
If you want to do it manually, put formulas in other columns (say columns C & D).
Formula in C1: "=(Countif($A:$A,A1)-Countif($B:$B,A1)"
Formula in D1: "=(Countif($A:$A,B1)-Countif($B:$B,B1)"
And copy them down 450 rows.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks