Formula for Exam Marksheet

  • Thread starter Thread starter Salza
  • Start date Start date
S

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.
 
=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)
 
Back
Top