Thread: How to filter email addresses on Excel ?
View Single Post
 
Old 05-31-2017, 06:43 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
In I2 enter:

MID(C2,FIND("@",C2)+1;LEN(C2)) and copy down. Name range with these formulas d.

In J2 enter the following array formula:

=IFERROR(INDEX(d,MATCH(0,COUNTIF($E1:E$1,d),0)),"" )

Remember to hold down Ctrl and Shift before pressing Enter. Copy the formula down.
Reply With Quote