+ Reply to Thread
Results 1 to 2 of 2

Letters = Numbers

  1. #1
    Forum Contributor
    Join Date

    Letters = Numbers

    I want to use 'ms'=4 , 's'=5, 'p'=2, 'j'=10
    so that when I type these letters into a cell I can then run an average based on the letters that will come back with a numeric figure.

    How do I do this?

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    You could use a helper column to set a value based on the contents of the cells, e.g.:

    =CHOOSE(MATCH(A1,$F$1:$F$4),4,5,2,10) copied down in col B with your list of criteria in F1:F4 (ms,s,p,j) would read the cells in Col A and return the listed values or #N/A if not matched.

    Then =AVERAGE(Bn:Bnnn) gives you the average of this range

    Does this work for you?
    The older I get, the better I used to be.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1