[Webinar] Learn how to a build a cloud-first strategyRegister Now


Excel finding value not exist in range.

Posted on 2011-04-28
Medium Priority
Last Modified: 2012-05-11
I have 2 columns:
A      B
1       2
2       4

and I want to find column C with value in column A but not exist in column B.

How can I do it?
Question by:JameMeck

Accepted Solution

Angelgeo earned 2000 total points
ID: 35489347
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35489520
If you like to have a macro you can use this. This will list the numbers continuously
Sub extna()
For Each cel In Range("A:A")
Set tl = Range("B:B").Find(cel, , , xlWhole)
If tl Is Nothing Then n = n + 1: Cells(n, 4) = cel
Next cel
End Sub

Open in new window


Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

868 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question