Related:
- Excel Formula Help
- @ in excel formula ✓ - Forum - Excel
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
- How to ignore false in excel formula ✓ - Forum - Office Software
- Number to words in excel formula - Guide
- Excel formula to transfer data between worksheets - Guide
2 replies
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