Unable to produce league table/chart based on data

Yes there is a way of doing this but it would be much easier if you posted that dummy worksheet - it's tough to edit a pic :-)

To add an attachment go to ADVANCED, Manage attachments, browse for your file, upload, close window, & save.

In the dummy file, mock up where & what answers you are expecting and highlight them in (say) green for DATA and Blue for your results, this way the Excel Guru's whose brains are almost at bursting point trying to interpret jpegs will probably supply an answer before you have had your sausage butties for lunch :-)

more than one way to skin a cat but this is what I'd suggest; using a pivot table. From here you can produce dynamic charts and quick filters to assist you analyzing the data.

I've chucked a couple of slicers in there to allow you to breakdown by employee or Week number.

I've added some more data to the table so if you click to refresh on the second sheet (ensure macros are enabled) then you'll see the table update.

Any questions just let me know.

Hope this helps.

Dave

Good answer from Dave, a pivot table works well for this kind of thing.

In the meantime I knocked this worksheet up earlier (because I was bored, and before you posted your attachment and 2nd criteria of using week numbers:-)

Using IFERROR INDEX MATCH formulas you can also determine the points awarded per employee and rank them in order top to bottom.
Other formulas used are RANK+COUNTIF and OFFSET MATCH.

INDEX MATCH can also be used with Week Numbers too.

Steve