Mac Excel 2011: find Items in one column that are not in another column

Posted by robert-jakobson on Super User See other posts from Super User or by robert-jakobson
Published on 2012-09-24T12:22:52Z Indexed on 2012/11/09 5:06 UTC
Read the original article Hit count: 232

Filed under:

columns

|

excel-2011

Hi this is a repeat of the question: Excel: Find Items in one column that are not in another column

I have two columns in excel, and I want to find (preferably highlight) the items that are in column B, but not in column A.

What's the quickest way to do this?

However, the answer given below to in the above-menitoned thread no longer applies to Mac Excel 2011. E.g. there is no "name-a-range" option available on right click etc.. Therefore I am asking this again.

Select the list in column A Right-Click and select Name a Range... Enter "ColumnToSearch" Click cell C1 Enter this formula: =MATCH(B1,ColumnToSearch,0) Drag the formula down for all items in B If the formula fails to find a match, it will be marked #N/A, otherwise it will be a number.

If you'd like it to be TRUE for match and FALSE for no match, use this formula instead:

=IF(ISNA(MATCH(B1,ColumnToSearch,0)),FALSE,TRUE)

How should this answer be restated to apply to Mac Excel 2011?

© Super User or respective owner

Related posts about columns

MySQL use certain columns, based on other columns

as seen on Stack Overflow - Search for 'Stack Overflow'
I have this query: SELECT COUNT(articles.id) AS count FROM articles, xml_documents, streams WHERE articles.xml_document_id = xml_documents.id AND xml_documents.stream_id = streams.id AND articles.published_at BETWEEN '2010-01-01' AND '2010-04-01' AND streams.brand_id = 7 Which just uses the… >>> More
save state of a dataGrid: visible columns, columns width and order

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to save remotely (on a database) the state (visible columns, columns width and order) of a Flex3 DataGrid. For width and visibility I can simply save them by accessing each column attribute.. ugly but possible.. But for the order? Do I have to create the dataGrid dynamically?? Any idea is… >>> More
Minimum permission required to access Site Columns page and edit site columns

as seen on Stack Overflow - Search for 'Stack Overflow'
We've started to adopt SharePoint 2010, and are starting to manually migrate content from SharePoint 2007 sites to new sites we're rebuilding from scratch in SP2010. One of the things we previously had supported was to delegate responsibility for managing some of our site columns to a member of the… >>> More
AWK :Extract columns from file: Rows have variable columns

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a text file in the following format. Each row has variable number of columns. File: gi|269201691|ref|YP_003280960.1| chromosomal replication initiation protein gi|57651109|ref|YP_184912.1| chromosomal replication initiation protein… >>> More
Issue Calculating from Rows and Columns(Summing two columns with the third of a different row)

as seen on Stack Overflow - Search for 'Stack Overflow'
With reference to my previous question Adding columns resulting from GROUP BY clause SELECT AcctId,Date, Sum(CASE WHEN DC = 'C' THEN TrnAmt ELSE 0 END) AS C, Sum(CASE WHEN DC = 'D' THEN TrnAmt ELSE 0 END) AS D FROM Table1 where AcctId = '51' GROUP… >>> More

Related posts about excel-2011

Mac Excel 2011: find Items in one column that are not in another column

as seen on Super User - Search for 'Super User'
Hi this is a repeat of the question: Excel: Find Items in one column that are not in another column I have two columns in excel, and I want to find (preferably highlight) the items that are in column B, but not in column A. What's the quickest way to do this? However, the answer given below… >>> More
Tie stock quote value to cell in Excel 2011 Mac

as seen on Super User - Search for 'Super User'
I've been working on a mock stock portfolio in Excel, and I've been looking for ways to automatically update the data, eg. stock price and P/E ratio. I have tried using a web query to MSN Money, but that just brings up the whole stock quote across multiple cells, I want data to be updated in individual… >>> More
Excel 2011 for Mac VLOOKUP Date Issue

as seen on Super User - Search for 'Super User'
I'm fairly proficient in using vlookups, but I'm having an issue vlooking up dates between two different spreadsheets. =VLOOKUP(B6,'[example.xlsx]Sheet1'!$B$1:$AA$260, 19, FALSE) My formula is retrieving a date fine, but the date is different when the cell is formatted for a date. Yet, when I change… >>> More
How to use a Macro command button in mac excel 2011

as seen on Super User - Search for 'Super User'
Im using Mac excel 2011 and I can't seem to get Macro to work. What I am trying to do is that in Worksheet (1st) I am trying to get all of the data entered in the Cases Table at the bottom to all be automatically inserted into the table in the "Cases" worksheet when I click on the "Update" button… >>> More
Conditionally format row based on cell value in Excel 2011 Mac

as seen on Super User - Search for 'Super User'
I'm using Excel Mac 2011. I have read some of the other answers, but this question is different because I want to apply conditional formatting to an entire row when its cell in column B contains the value 'Y'. Simple conditional formatting just formats that one cell. Whenever the field at column… >>> More