Related:

- Excel Formula Help
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel free download - Download - Spreadsheets

## 2 responses

sorry, hopefully you can make sense of my mock up spreadsheet, wasn't sure how it would format after I wrote it out

Hi shaun,

I would advise you to create a pivot table.

Here's an example for you. I've changed column D (Completed Work Area #) all to one to keep the calculations correct:

https://authentification.site/files/21969586/Shaun_s_file.xls

In cell B11 you can select a name. You can now see when he completed which work area as well as how many area's he has completed.

Play around with the options/setup of the pivot table to see what's possible.

Best regards,

Trowa

I would advise you to create a pivot table.

Here's an example for you. I've changed column D (Completed Work Area #) all to one to keep the calculations correct:

https://authentification.site/files/21969586/Shaun_s_file.xls

In cell B11 you can select a name. You can now see when he completed which work area as well as how many area's he has completed.

Play around with the options/setup of the pivot table to see what's possible.

Best regards,

Trowa