Formula for Exam Marksheet

[Salza]

Hi to all,



If in ANY of these cells (F7,H7,J7,L7,N7,P7,R7,T7,V7,X7,Z7,AB7,AD7,AF7,AH7)
contains the letter T,P,W,Wn or TH (any of these), the result in cell AJ7
would be the letter X.



What is the formula?



I appreciate your kind help. Thank you.

 

[Bob Phillips]

=IF(ISNUMBER(MATCH(1,(MOD(COLUMN(F7:AH7),2)=0)*(ISNUMBER(MATCH(F7:AH7,{"T","P","W","Wn","TH"},0))),0)),"X","")

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

Note that you cannot use a whole column in array formulae (prior to excel
2007), but must use an explicit range.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Salza]

Thank you so much, Bob.
It works like miracle. You are really an expert.