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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

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,114,645
Messages
5,549,156
Members
410,902
Latest member
G Slim
Top