Darren_workforce
Board Regular
- Joined
- Oct 13, 2022
- Messages
- 146
- Office Version
- 365
- Platform
- Windows
Hello,
I have a spreadsheet listing queue staff from B through J. The queue name is in cell 1 and the agent names within each queue take up the rest of the columns. My formula below works to count up all unique individuals across the spreadsheet but it obviously does not take into account any color coding I've assigned to each agent (full-time, part-time, etc). I have been unable to locate anything online so I was curious if the formula below could be adjusted with vba to count up not only the unique names but also only those names that have a particular color code? (If it helps, my full-timers are coded with conifer green 146, 208, 80 || #92D050)
Thank you in advance for any assistance!!
I have a spreadsheet listing queue staff from B through J. The queue name is in cell 1 and the agent names within each queue take up the rest of the columns. My formula below works to count up all unique individuals across the spreadsheet but it obviously does not take into account any color coding I've assigned to each agent (full-time, part-time, etc). I have been unable to locate anything online so I was curious if the formula below could be adjusted with vba to count up not only the unique names but also only those names that have a particular color code? (If it helps, my full-timers are coded with conifer green 146, 208, 80 || #92D050)
Excel Formula:
=SUMPRODUCT((B2:J35<>"")/(COUNTIF(B2:J35,B2:J35)+(B2:J35="")))
Thank you in advance for any assistance!!