Hi,
I am using the following formula to look for grades that have been achieved across multiple sheets.
I have a list of grades that i have defined as the name GRDS.Please Login or Register to view this content.
This is the list of grades
1
2
3
4
5
6
7
8
9
A*
A
B
C
D
E
F
G
P
M
D
D*
L1
L2
But for some reason it only seems to return the number of values of 1's? is this due to the grades being a combination of numbers and letters?
Thanks
Jamidd
Bookmarks