Forum Discussion
Create new cells based on values present in other Sheets
With your permission, if I may recommend, it would be beneficial to know the Excel version, operating system and storage medium.
A file (without sensitive data) or a photo so you can come up with a solution much faster and we don't have to waste time guessing. Win-win for both :).
Thank you for your understanding and patience
I know I don't know anything (Socrates)
Hello NikolinoDE
I am using Excel LTSC Professional Plus 2021 on windows 10.
I am creating a sheet to track defects raised during projects. When a defect is found it is allocated to a person. This person's initials will be typed in not selected from a list as any person could potentially be added.
See below example of 5 allocations, with 4 unique individuals
I then have a summary page, where i would like to show each person who has an action allocated, so i can provide statistics on how many allocations each person has, as well as how many items they have completed and how many items are outstanding.
So basically im trying to workout how to automatically populate this table with each unique person and their applicable counts. Each time a new person is added to the "Allocated To" column of the initial table they should be automatically added to the "Action Responsibilites" column of the summary table.
Hope this helps
Thanks