Results 1 to 2 of 2

Thread: Is it possible

  1. #1
    Join Date
    Feb 2004
    Location
    Vermont
    Posts
    53

    Unanswered: Is it possible

    So I have a spreadsheet that has in each cell a code that looks like the following "NYL5". What I want to do is take the 4th character in this code with is always number and add them all together in a column and then calculate the average. Is this possible at all? If so can you tell me how?

    Thanks,

    stuck

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    Yup its possible

    Try something like this to get the 4th character
    =INT((RIGHT(LEFT(A1,4),1)))

    Then just use the average function

    All the best
    Dave

Posting Permissions

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