Use excel to do something with email addresses

OU812 · 21-09-2015 02:13PM #1

I have a spreadsheet with several hundred people on it. One of the fields is their email addresses all in one column. I want to be able to find out how many people use Hotmail/gmail/other/corporate addresses & find that out as a percentage

e.g. 100 users, 27 use hotmail, 36 use gmail, 13 use corporate email, 24 use other email (.edu etc)

Is there a formula that will examine the email column & look at everything after the "@" symbol & give me this info in another sheet ?

MissFlitworth · 21-09-2015 02:25PM

Once you know all the email domains you want to count you could do this using countif

so, for hotmail =countif([range], "*@hotmail.com") will count every entry in a range with @hotmail.com in it, regardless of what's before the @. =countif([range], "*@gmail.com") will do the same for Gmail addresses etc.

Gordon · 21-09-2015 02:27PM

You could always save the excel file as text, then import only the email column into a new excel file and use the @ symbol as a delimiter. This will give you two columns, the email name and the provider. For which you could then sort/count etc.