I have a row of data:
JAN FEB MAR APR MAY CURRENT GRADE
2a 2b 2c 3a 3b
They are pupils grades each month.
I would like to display the most recent grade in the last column but cannot workout a formula to do it. I know it can be done if the grades were purely numbers 2,3,4,5,6 but can it be done when they are entered as text e.g. 2a, 2b, 2c ?
Last edited by BobTheRocker; 09-28-2010 at 10:16 AM.
=LOOKUP(REPT("z",255),A1:F1)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Spot on, thankyou very much works a treat!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks