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
HOW PLZ HELP
harru
5 March 2020 11:34
#4
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?
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
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:
Select all of column two and hit “Format As Table”
in cell C1, enter the following: =IF((ISNA(VLOOKUP(A1,Table1,1,FALSE))),"Unique","Duplicate")
Drag the formula in C1 down to match the length of your list in column A
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?!
Steved
3 November 2020 12:11
#25
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?