SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

[excel] Excel how to find values in 1 column exist in the range of values in another

I have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns contains some code details.

Something like this

A               B
q123           as124
as124          gh456
ff45           q123
dd1             dd2
xx2
xx3
xx4

and so on...

I want to find if the names in column A exists in column B or not.using excel

This question is related to excel excel-2007 excel-formula excel-2010 vba

The answer is

Use the formula by tigeravatar:

=COUNTIF($B$2:$B$5,A2)>0 – tigeravatar Aug 28 '13 at 14:50

as conditional formatting. Highlight column A. Choose conditional formatting by forumula. Enter the formula (above) - this finds values in col B that are also in A. Choose a format (I like to use FILL and a bold color).

To find all of those values, highlight col A. Data > Filter and choose Filter by color.

Source: Stackoverflow.com

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to excel-2007

• Declare a variable as Decimal • filter out multiple criteria using excel vba • Excel Formula which places date/time in cell when data is entered in another cell in the same row • Creating a list/array in excel using VBA to get a list of unique names in a column • Delete all data rows from an Excel table (apart from the first) • Excel formula to get week number in month (having Monday) • Run-time error '1004' - Method 'Range' of object'_Global' failed • A formula to copy the values from a formula to another column • Excel how to find values in 1 column exist in the range of values in another • Delete entire row if cell contains the string X

Examples related to excel-formula

• Excel doesn't update value unless I hit Enter • Referencing value in a closed Excel workbook using INDIRECT? • Conditionally formatting cells if their value equals any value of another column • Sum values from multiple rows using vlookup or index/match functions • What does an exclamation mark before a cell reference mean? • If two cells match, return value from third • Excel - programm cells to change colour based on another cell • Format numbers in thousands (K) in Excel • Excel Formula which places date/time in cell when data is entered in another cell in the same row • Excel formula to display ONLY month and year?

Examples related to excel-2010

• Get list of Excel files in a folder using VBA • filter out multiple criteria using excel vba • Swap x and y axis without manually swapping values • Excel 2010 VBA - Close file No Save without prompt • Removing special characters VBA Excel • Creating a list/array in excel using VBA to get a list of unique names in a column • Excel formula to get week number in month (having Monday) • Excel VBA Run-time Error '32809' - Trying to Understand it • IF statement: how to leave cell blank if condition is false ("" does not work) • Excel how to find values in 1 column exist in the range of values in another

Examples related to vba

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?