Cheers Braz.
Right gents
I have two columns of data. Column A with 18000+ entries and B with 12000+ entries. The vast majority of the 12000+ entries also appear in column A
I want to find which entries in A are unique and do not appear in B.
Anyone have any suggestions aside from a Vlookup
More a SQL thing I would have thought.
Write a quick macro?
Be my guest
You need filters.
What do the entries start with?
Do they all start with numbers? Or all start with letters?
If so maybe a simple sorting could work?
That is why you are top dog around here
Chewy should be donating a percentage of his salary to the forum. He doesn’t appear to be able to do his job at all.
Question:
I have two seperate sets of data in a spreadsheet.
The first has two columns of data with 39451 rows while the second set of data has three columns 40194 rows and three columsn of data.
The first coumn of first set has the same information as the second column in the second set. Is there a straightforward way of removing the 750 odd entries from the second column? (all three columns would be needed to be deleted)
Yeah just do a vlookup to find if the data is common, make that say yes or no, then sort and delete the no rows.
I have done something similar and it has worked in a round about way
You can also use conditional formatting to do the same thing.
Has anyone used Excel on an Apple laptop. Likely to be changing jobs shortly to a company which use Apples. I’m not that familiar with them but full Excel functionality and usability would be a concern
It will be the same whether you are using Excel on apples or on oranges. 
Oranges can probably handle large data sets and pivots better than Apples can though.
Wouldn’t surprise especially after the last update that Apple put out for the Iphone. :mad:
(Excel for) Apple Mac?
How heavily do you use excel?
Pretty heavily - mostly for detailed financial models etc rather than heavy data processing.