I have the attached sheet, in which, I want to tally my two columns with each other and extract that numbers of 1st column which not available in 2nd column and that numbers of 2nd column which not available in the 1st column.
Please help to solve my problem
Enter formula in C2 and copy down
Formula:
Please Login or Register to view this content.
v A B C 1 1st Col 2nd Col Formula 2 123455 123451 NOT FOUND 3 123457 123457 FOUND 4 123458 123458 FOUND 5 123454 123454 FOUND 6 123460 123461 NOT FOUND 7 123464 123464 FOUND 8 123465 123465 FOUND 9 123466 123467 NOT FOUND
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Why not COUNTIF?
Quang PT
Some people like to type!Originally Posted by bebo021999
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks