Hi bighop,

1. For students with no points and don't have a name in the Suggest tab, here is how to grab them. There are two different ways. On the Lookup Tab next to all students name create a formula to countif times there names are on the Suggest Tab. Or, add each students name to the Suggest tab with no code. You could then filter all students with count of code equal 1.

2. Pivot Tables can be grouped using Year, Quarter, Month or number of day ranges. See http://www.contextures.com/xlPivot07.html or http://www.pivot-table.com/pivot-tab...by-fiscal-year

For another hint. As you add rows of data onto your Suggest Tab you will want the rows handled in the Pivot Table to grow automatically. Excel has a feature called Dynamic Named Ranges that will be helpful. See: http://www.ozgrid.com/Excel/DynamicRanges.htm or http://www.contextures.com/xlNames01.html