Viewing 5 posts - 1 through 5 (of 5 total)
  • excel help
  • anagallis_arvensis
    Full Member

    how can I get excel to convert a kids key stage 3 level into a numerical value eg 8 = 13, 7a=12, 7b=11 7c= 10 6a= 9 etc and back again?

    Stoner
    Free Member

    Create a reference table somewhere where the corresponding values are listed next to each other and use vlookup or match&offset to return the correct one.
    Or use a long-winded conditional statement.

    My preference is the former.

    Markie
    Free Member

    Vlookup would be my starting point…

    Edit: as stoner just said! Like him, I’d shy away from an epic if statement, they can be dreadful to alter or debug!

    Fresh Goods Friday 696: The Middling Edition

    Fresh Goods Friday 696: The Middlin...
    Latest Singletrack Videos
    anagallis_arvensis
    Full Member

    thanks I’ll try that later ans will no doubt be back with further questions!!

    Stoner
    Free Member

    I’m here all morning 🙂

Viewing 5 posts - 1 through 5 (of 5 total)

The topic ‘excel help’ is closed to new replies.