Formula for Exam Marksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Salza - 07 Mar 2008 08:00 GMT

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.

Reply to this Message

Bob Phillips - 07 Mar 2008 10:42 GMT

=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.

Signature

---
HTH

Bob

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

> Hi to all,
>
[quoted text clipped - 6 lines]
>
> I appreciate your kind help. Thank you.

Reply to this Message

Salza - 07 Mar 2008 12:26 GMT

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

> Hi to all,
>
[quoted text clipped - 6 lines]
>
> I appreciate your kind help. Thank you.

Reply to this Message

Rate this thread: