What formula works for this

richardthelionheart

Board Regular
Joined
Mar 25, 2016
Messages
89
I need to create a formula to solve this question (put in plain english) so I ask Excel:
Look for x in the following cells AI89:AM94 and if you find x put an x otherwise put a 1 if you can only find numbers
Any help is greatly appreciated.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

philwojo

Well-known Member
Joined
May 10, 2013
Messages
533
Not totally sure this is what you want, but you can try it. This doesn't care if it finds more than one "x" in your range, it just looks in that range and says if there is 1 or more X's then put an X where you place this formula, otherwise put the number 1.

Code:
=IF(COUNTIF($AI$89:$AM$94,"x")>1,"x",1)

See if this works for you.
 

richardthelionheart

Board Regular
Joined
Mar 25, 2016
Messages
89
Not totally sure this is what you want, but you can try it. This doesn't care if it finds more than one "x" in your range, it just looks in that range and says if there is 1 or more X's then put an X where you place this formula, otherwise put the number 1.

Code:
=IF(COUNTIF($AI$89:$AM$94,"x")>1,"x",1)

See if this works for you.

Yes, that worked perfectly. Thank you very much philwojo.:)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,502
Messages
5,529,245
Members
409,857
Latest member
KailuaTown
Top