Upload

Loading...

Grade Printouts in Excel

504 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Mar 24, 2013

Shows how to make a grade printout in Excel. It cleverly uses a PivotTable.
The workbook is available at http://web.mit.edu/jabbott/www/excelg....

The main formula used for lookup:
=IFERROR(OFFSET(*CellToStartOffsetWith$$­*,0,MATCH(RIGHT(*CelltoLookup*,LEN(*Cell­ToLookup)-1),*WhereToLookup*,0)-1),"­;")
I then surrounded this with an if-statement to ignore values of 0.

A different method on grade printouts can be found: http://blogs.office.com/b/office-educ.... Microsoft here uses a macro and a graph. Not very customizable, but sleek.

  • Category

  • License

    • Standard YouTube License

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up Next


to add this to Watch Later

Add to