Assuming achieved grade is in column A, and target grade is in column B, then you can have this in C1:
=CODE(SUBSTITUTE(B1,"A*","@"))-CODE(SUBSTITUTE(A1,"A*","@"))
Hope this helps.
Pete
Assuming achieved grade is in column A, and target grade is in column B, then you can have this in C1:
=CODE(SUBSTITUTE(B1,"A*","@"))-CODE(SUBSTITUTE(A1,"A*","@"))
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks