+ Reply to Thread
Results 1 to 6 of 6

grading

  1. #1
    Registered User
    Join Date
    10-07-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    4

    grading

    i have data as follow:


    Student 1 66 B 78 A 43 D 64 B 43 D 43 D 43 D 80 A


    what is the function if I want it to be appear like this..


    Student 1 66 B 78 A 43 D 64 B 43 D 43 D 43 D 80 A 2A2B4D

    thanks for your help..

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: grading

    Are you just counting number of A's, B's, C's ?

    How many letters are there to count in total? What are they?

    Are the letters and numbers in your samples in separate cells?
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    10-07-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: grading

    yes i just want to count numbers of A's, B's, C's.

    there are 3 letters in the samples A, B and D.

    Yes the letters and numbers are in separate cells.
    Last edited by senduk73; 10-07-2009 at 03:27 PM.

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: grading

    Assuming the items are in A1:P1, try:

    Please Login or Register  to view this content.
    adjust as necessary

  5. #5
    Registered User
    Join Date
    10-07-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: grading

    it works!! thanks 4 your help..you are awesome dude!!

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: grading

    You are welcome.

    I noticed you edited your post to say that there are 3 letters A, B, D... there are never any C's or E's?... if not, you can remove those sections from my formula...

    Please also mark your thread as [Solved]... follow link in my signature to see how.
    Last edited by NBVC; 10-07-2009 at 04:06 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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