Using: Excel 2010
I will have a list of hundreds of documents (with document numbers ranging from 1 to say 1000 but not always sequential). In a nearby column, there will be a Due Date (which may be updated sometimes based on input from the author). This will be my source table
I'm trying to create a Pivot Table which creates a table with all of the Due Dates as Column Headings and would list under each Due Date, sorted numerically, the Docs that are due that day. At the bottom of each row would be the total number of docs due that day.
The attached picture shows what I'm trying to do.