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

HOW PLZ HELP

Remove duplicates

doesnt work

Ok well youâ€™ve beaten me, congratulations.

NO IGNORE ME I STILL NEED HELP

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

yes

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â€ť

https://www.extendoffice.com/documents/excel/3250-excel-compare-two-columns-and-delete-matches.html

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?