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