please help an excel numpty

i have a spreadsheet

in the spreadsheet there are just two columns, both have email addresses

i want to identify the times where an email address is in both columns, and then when it is in both columns, i want that email address to be deleted, and i just want to be left with the addresses not in both columns


Remove duplicates

doesnt work

Ok well you’ve beaten me, congratulations.


That won’t work because it will leave a single version of all the duplicates you had and you want them both gone, no?

fuck sake


Put this in a third column =IF(A11=B11,1,0)

then sort on that column and delete all the 1s

doesn’t work

most likely because i’ve no idea how to do anything in excel


can you show this bit

i’m really thick, i’m so sorry

I searched on “excel compare two columns and delete matches”

Does this help?

You then need to sort columns a to c all together on C and then delete everything where C is a 1.

I’ve got a pretty faffy solution using tables and VLOOKUP if you’re still working on this:

Assuming you’re set up like @anon29812515 posted above:

  1. Select all of column two and hit “Format As Table”
  2. in cell C1, enter the following: =IF((ISNA(VLOOKUP(A1,Table1,1,FALSE))),"Unique","Duplicate")
  3. Drag the formula in C1 down to match the length of your list in column A
  4. Sort the lot alphabetically on column B and delete all the rows that say “Duplicate” in column B

It’s not neat, but it works…

Ahh, I assumed they were next to each other…

they’re not next to each other, if an identical email appears they may well be in different rows

1 Like

Could you do some conditional formatting for duplicates, then filter on the formatting and delete the rows?

Is this the most recent one of these?

I’m currently trying to make a summary report/dashboard and struggling to think of an easyish way to do this.

Got 3 measures per project on a monthly basis, RAG rated with the table currently looking like this

Wanna make a summary page on a separate workbook with tables & charts which counts totals, with a drop-down month selection.

Does this make any sense?!

Just to clarify, is what you’re after a page with two dropdown boxes, one for project and one for month? And then you’d have a load of charts and that driven by the dropdowns, so that if you selected project 2 and November you’d get those results?