Remove Duplicates so you only see unique records

Get all of the data into one column, then something along these lines:

=IFERROR(INDEX($A$2:$A$10,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$10),0,0),0)),"")

where A2 to A10 is your original list with duplicates.

Must be entered into B2 - won't work in B1. The B column reference needs to reference the cell ABOVE where the list starts.

Sorry - I don't understand your data. There are no duplicates: each row is different, as far as I can see. Are there meant to be three columns here? Perhaps you should provide us with a representative sample of your data?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Could you please provide a workbook?

Thanks. I don't see where you have tried to use the formula or given any expected outcomes. Is the duplication you want to get rid of dependent on the Email column? If so, use my formula to filter out the duplicates in that column and then do a VLOOKUP or INDEX MATCH to pull through the associated data.

I am trying to completely understand - honest! :-)

I added a question to my last post: did you see it?

Does this help:

Excel 2016 (Windows) 32 bit

	L	M	N	O	P	Q
1
2	[email protected]	---	Evan	Young	Independant Tour Merchandise Manager
3	[email protected]	"Daily Planet" on Discovery Canada	Dawsyn	Borland	Associate Producer
4	[email protected]	#paid	Maxime	Houde-Shulman	Account Manager
5	[email protected]	?????????	Andy	zhang	Sales Manager
6	[email protected]	??????????????	xu	an	????
7	[email protected]	`	Jodi	Fenwick Yackness	Assistant Director
8	[email protected]	1 litre water company	Arie	Sibonney	President
9	[email protected]	1215creative	Jennifer	Duong	Director of Virtual Reality
10	[email protected]	20/20 Armor	Ali	Ghafour	Founder, CEO, Director
11	[email protected]	20th Century Fox	Mike	Morgan	Director, Production & Post Production Technology; Fox Innovation Lab

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	L	M	N	O	P
2	=IFERROR(INDEX($D$2:$D$17,MATCH(0,INDEX(COUNTIF($L$1:L1,$D$2:$D$17),0,0),0)),"")	=INDEX($A$2:$A$17,MATCH($L2,$D$2:$D$17,0),0)	=INDEX($B$2:$B$17,MATCH($L2,$D$2:$D$17,0),0)	=INDEX($C$2:$C$17,MATCH($L2,$D$2:$D$17,0),0)	=INDEX($E$2:$E$17,MATCH($L2,$D$2:$D$17,0),0)

Sheet: Sheet1

Did you consider yet a pivot table ?
This feature is specially designed for that.

I tried using Advanced Filter -> Unique records -> copy to another location and got the following result. Is that the result you are looking for?

Advanced filter tutorial: http://www.contextures.com/xladvfilter01.html

All I want is to see the non duplicate data. So I don't want "Evan Young" as a result

Are we to understand that the desired output is more like this?

Row\Col	H	I	J	K	L
1	Company	First	Last	Email	Position
2	"Daily Planet" on Discovery Canada	Dawsyn	Borland	[email protected]	Associate Producer
3	#paid	Maxime	Houde-Shulman	[email protected]	Account Manager
4	20/20 Armor	Ali	Ghafour	[email protected]	Founder, CEO, Director
5	20th Century Fox	Mike	Morgan	[email protected]	Director, Production & Post Production Technology; Fox Innovation Lab

I am guessing you have already tried 'Remove Duplicates' under the 'Data' tab in the 'Data Tools' section? No-one seems to have mentioned this and I cannot see why it would not work with your data..

Edit: I downloaded your data file, highlighted all of the data, clicked 'remove duplicates' clicked 'select all', and then 'ok'. It removed the 6 duplicates leaving me with the 10 unique values.