Certificate help

Hi all.

I'm new here so forgive my stupid questions.

I have created an intelligent martial arts grading form. I can mark students on a created Microsoft Excel spread sheet on my laptop. The sheet will add up scores, and it will create a list with students scoring over 50% it will create a new page that will have their name and Pass or fail on it, as well as the grade they achieved. Students scoring over 70% it will come up "A Pass" I then mail merge this sheet through Word and it prints certificates with the correct information of for each student. So all I do is enter scores for each part, the program does the rest.

However, I'd like to add one more function I am struggling with. I have a final sheet I call certificate sheet. It has all the names in order, the grades and the scores all linked from separate pages. It will, using an "IF" command put "A Pass" on certificates if scored over 70% however I'd like to also add "Best in Grading" to the highest score of the grading.

Is there a formula, I can add to the score cells to decide the highest number and then add "Best of Grading" to a neighboring cell on the sheet. so it can be selected on word for mail merge.

I hope that all makes sense.

thank you

Without a sample sheet it is difficult to offer a solution but perhaps the MAX function to get the highest score?

This might help if you insert this into a helper column.

i agree with JohnTopley
something like
If(a2=max(a3:g3),"best in grading","")

without a sample workbook it is hard to do more

Thanks all. Is there away I can upload my sheet here?

Click Reply go advanced then manage attachments, use the file manager to add your attachment.

Hi I think It should be attached.

Originally Posted by TKDjon

Hi I think It should be attached.

It is attached.

btw, I love the oxymoron. 'Intelegent' sheet as opposed too "Intelligent"

Haha yes well spotted.

Originally Posted by TKDjon

Haha yes well spotted.

Here you go.

thank you. I think I know those students you put in...... thanks again

Originally Posted by TKDjon

thank you. I think I know those students you put in...... thanks again

You should see the names I took out

Your welcome btw.

Hi BlindAlley its me again Just trying out the formula, which is great by the way. Only trouble I'm having now is for my mail merge certificate printing the "Best in Grading" needs to be on the same line as the persons name. for example if the students in cell B22 is the highest score for the entire grading, the "Best in Grading" needs to appear in cell G22 so on Word it prints line by line. reading data from each line and adding it to the correct certificate. I hope that makes sense. As Asswipe defiantly wasn't the best lol

I managed to do it. I used your MAX formula to find the highest score, then I had a column with =IF(E2=$H$2,"Best In Grading","") in it. where cell H2 contained the highest score.

Originally Posted by TKDjon

I managed to do it. I used your MAX formula to find the highest score, then I had a column with =IF(E2=$H$2,"Best In Grading","") in it. where cell H2 contained the highest score.

That's the thing with Excel, there's always a way, perseverance is the key