1. L

    How to include A* GCSE Grades in a VLOOKUP Table?

    I use excel as my school mark book. This involves needing to convert grades (letters) into numbers and vice versa. I am able to use a vlookup table for the majority of this. However I have found an anomoly when trying to include grades at A-star (A*). I have included a table like this to show...
  2. timetabler

    Counting Grades

    I am trying to count the number of grades a student has acheived that are above a grade C. I have a named range called gcsegrades which have each grade and their relevant point value on another sheet. d=34 c=40 b=46 a=52 Rather than doing a a vlookup against each and every-cell is there a...

Some videos you may like

This Week's Hot Topics