I have a column of email addresses of employees at different companies and some companies have up to 20 emails on file (different names but same suffix). If a company has multiple addresses they show going down the list as A1- address1; A2- address1 | address2; A3- address1 | address2 | address3 etc. (it must be formatted this way to import the info into a template)
There are also companies with a singular address, which is just a singular email address in the cell by itself.
What I need is to only be left with a singular cell for each company, effectively singling out the last row per company (which contains every relevant email address for each company)
AS WELL AS bringing over the singular email addresses (ones that don't have multiple addresses per company)
I've tried trimming the column and using the formula =IF(ISERROR(FIND(" ",A1)),,A1) to complete this but it works for maybe 70% of the companies with multiple addresses and not at all for companies with a singular address (which i figured)
Any help on this would be awesome as I have little to no prior excel experience and I've been stuck on it for longer than I'd like to admit.
There are also companies with a singular address, which is just a singular email address in the cell by itself.
What I need is to only be left with a singular cell for each company, effectively singling out the last row per company (which contains every relevant email address for each company)
AS WELL AS bringing over the singular email addresses (ones that don't have multiple addresses per company)
I've tried trimming the column and using the formula =IF(ISERROR(FIND(" ",A1)),,A1) to complete this but it works for maybe 70% of the companies with multiple addresses and not at all for companies with a singular address (which i figured)
Any help on this would be awesome as I have little to no prior excel experience and I've been stuck on it for longer than I'd like to admit.