Hi guys,
I am trying to count how many times a text appears next to a staff ID across 5 columns. I foolishly thought a countifs formula would sort it, but I'm getting an error so that's obviously not right
Below is an example of the data I'm working from (I can't attach a workbook...)
What I want is column headers Staff ID, Name, Personal Effectiveness, Business Management, Customer Service, Leadership, Audits, Health & Safety, Talent Management, Performance Management, Recruitment, then a count of how many time that has appeared in the 5 development needs columns - i.e. Aaron would have a 1 under Personal Effectiveness, a 2 under Business Management, and a 2 under Customer Service
Original Data
<tbody>
</tbody>
I am trying to count how many times a text appears next to a staff ID across 5 columns. I foolishly thought a countifs formula would sort it, but I'm getting an error so that's obviously not right
Below is an example of the data I'm working from (I can't attach a workbook...)
What I want is column headers Staff ID, Name, Personal Effectiveness, Business Management, Customer Service, Leadership, Audits, Health & Safety, Talent Management, Performance Management, Recruitment, then a count of how many time that has appeared in the 5 development needs columns - i.e. Aaron would have a 1 under Personal Effectiveness, a 2 under Business Management, and a 2 under Customer Service
Original Data
Staff ID | Name | 1st Development Need | 2nd Development Need | 3rd Development Need | 4th Development Need | 5th Development Need |
41726 | Aaron | Personal Effectiveness | Business Management | Customer Service | Business Management | Customer Service |
101651 | Aashna | Talent Management | Business Management | Customer Service | Health & Safety | |
27956 | Abhishek | Performance Management | Audits | Leadership | ||
66341 | Aby | Customer Service | Talent Management | Performance Management | Recruitment |
<tbody>
</tbody>