Formula

[Abdul Rahman]

Help appreciated.

How can i solved the formula on the blue highlighted range.

Thank you

[JohnTopley]

Are you still on Excel 2003/2007 ? If not, please update your profile.

And what are criteria for "pass" or "Fail" ?

[Abdul Rahman]

Updated Excel 2013

Dont mind about the Result Range, I will solved later

Can I use any formula applied to Overall Grades Range that can give the answer 2D 3E such as Concatenate, CountIf, etc

Thank you for your help. Appreciated

[JohnTopley]

UDF

Please Login or Register  to view this content.

=grades(C4:G4)

[Abdul Rahman]

Wow Thank you very much Sir. Amazing

How I wish I can do VBA.

Can I use the Code if the Grade is in separate column?
And how to write the code for the RESULT criteria?

Im sorry for the inconvenience caused.
Thank you for your most helped. Appreciated.

[JohnTopley]

Not clear on criteria for Pass/Fail: it appears not to be simply having (at least) one "E" grade.

2A 1C 1D 1E = Pass

1A 1B 1C 1D 1E = Fail (W15)

1A 1B 1C 1D 1E = Pass (W28)

unless results in W reflect your Final Grade vs Macro calculation i.e they are different

????

[Abdul Rahman]

Im really sorry Sir John for troubling you.
This is my first time posting some data and needed some help
I might be too excited then.

Thank you very much for your help and reply
Im really appreciated for your expertise.
I think that all for now
considered SOLVED
Have a Nice Day

[Abdul Rahman]

Oh you did reply. Im sorry overlooked

[JohnTopley]

So is "Fail" simply having at least an "E" (as per attached) ? If not, let me know the criteria.

[Abdul Rahman]

This is my wife's marksheet and have not yet finished, RESULT are done manually

for the grade, if any student got E, result should be Fail (solved)
but if I fill in all Pass result such as 2A 1B 1C 1D the result give #VALUE

[Abdul Rahman]

Yes Sir
and if they got no "E" then should be in PASS result

[JohnTopley]

Change W9 to

=IFERROR(IF(FIND("E",V9),"U"),"P")

copy down

[Abdul Rahman]

Done. Amazing.

Thank you very much Sir, youre most appreciated.
You SOLVED my problem

[JohnTopley]

Please can you mark as SOLVED: see "Thread Tools" at top of the page. Thank you.