Creating a progress chart

Hi Teylyn,

Thanks for the help! I've attached a sample with this post: the raw data is contained within the "Data" worksheet (only the essential columns, my original has other columns such as date and duration but essentially I only need to know if the course exists), with the desired end product in the last worksheet.

I've toyed around with pivot tables but my concern is that the criteria list changes frequently, resulting in the formatting being messed up, and also the problem of not updating automatically. It should also be as user-friendly as possible since this will mainly be used by people with minimal excel knowledge. As new information comes in, one should only have to update the "Criteria" worksheet and see the changes reflected in the final product.

Thanks again!