Results 1 to 11 of 11

Grade book with varied weightings; letters to numbers to letters

Threaded View

  1. 08-29-2022, 08:22 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,775

    Re: Grade book with varied weightings; letters to numbers to letters

    Give this a go in K4:

    =INDEX('Grade determination'!$B$3:$B$17,MATCH(ROUND(SUMPRODUCT(((SUBSTITUTE(H4:J4,"N","")<>""))*({0.4,0.4,0.2})*('Grade determination'!$B$3:$B$17=H4:J4)*('Grade determination'!$C$3:$C$17))*(1/SUMPRODUCT((H4:J4<>"")*(H4:J4<>"N")*({0.4,0.4,0.2}))),0),'Grade determination'!$C$3:$C$17,0))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to work out the average grade (letters A-D) with a formula?
    By PhilEvans in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-25-2019, 10:37 AM
  2. [SOLVED] Varied range count , numbers , decimal , letters .
    By I need excel help in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2018, 03:19 PM
  3. [SOLVED] Removing varied number of letters from end of number-letter string
    By WhiskeyGolf in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 04-16-2015, 04:43 AM
  4. Sort Alphabetically letters and numbers(column) - sorted letters on the top in the column
    By Ferddy in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-27-2014, 11:05 AM
  5. Removing two letters from a string of letters and numbers
    By FobesA in forum Excel General
    Replies: 13
    Last Post: 07-30-2014, 12:03 PM
  6. Parsing Letters and Numbers (And Letters)
    By jontran718 in forum Excel General
    Replies: 6
    Last Post: 01-12-2012, 12:55 PM
  7. Excel 2007 : pull letters out of cell with letters & numbers
    By gill389 in forum Excel General
    Replies: 2
    Last Post: 12-01-2010, 02:29 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1