Lookup existence of a cell phone text number
Sorry.. Cntrl-Shift-Enter for array formula.
On Jan 15, 5:06*pm, willwonka wrote:
Give the range of your text providers a range name. *I'll use the
range name "data".
The list of your names or in Column A
col a * *Col b
Bill * * {=IF(ISNUMBER(FIND(data,C1,1)),"yes","no")}
Make sure that you hit Cntrl-Alt-Enter to make it an array formula
On Jan 15, 4:53*pm, 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- Hide quoted text -
- Show quoted text -
|