Expand this list to your full seven options, don't forget the asterisk
wildcard at the beginning of each one:
=IF(SUM(COUNTIF(A1,{"*zmail.biz","*vtext.com","*tx t.att.net"}))0,"Yes","No")
A1 = first email address to check.
--
"Actually, I *am* a rocket scientist." -- JB
Your feedback is appreciated, click YES if this post helped you.
"MarkMcG" wrote:
Excel Wizards,
I have a list:
Name Device
-------- ---------
Bill
Bill
Sue
Sue
Randy
Randy
I need to lookup, yes or no, if each unique user has registered any text
device. I know that the device can be registered from 7 different carriers
(vtext.com, txt.att.net, etc).
How to do this in a formula so to get:
Name Text Device
-------- ---------------
Bill No
Sue Yes
Randy Yes
Many thanks, Mark