Name Manager

Question

Hi,

I have a rather unusual problem. I am a teacher and I am working with Excel to gather my students' grades. I use A,B,C,D,F as a grade format. As I need to be able to count these letters - for example when writing tests or exams - and come up with a grade average, I need to assign these letters the numbers 1 to 5. So A would be 1 and so on.

I realized that you can use the name manager to assign numbers to certain letters. I can create a name called "A" and assign number 1 to this name, so whenever I write "A" somewhere, Excel 'counts' the "A" as number 1 and I can calculate grades with it. This works fine, except for the letter "C". I don't know why, but the name manager wouldn't let me assign the name "C" to number 3. In all other cases it works.

Is there an explanation for this?

Answer 1

The letters R & C are reserved for Row and Column.

If you were to "create from Selection", the name manager would prefer to rename them to C_ and R_