Nov 28 2017
07:43 AM
- last edited on
Jul 25 2018
10:29 AM
by
TechCommunityAP
Nov 28 2017
07:43 AM
- last edited on
Jul 25 2018
10:29 AM
by
TechCommunityAP
Hi I'm trying to take all of our employee's diversity information (similar to the example A) and transfer the data to example B). We have around 6,000-7,000 employees and I've tried several countif formulas, but my numbers don't match what is on example A when I audit. Please let me know if you have additional questions.
Groups | Worker | Gender | Race |
Events | Ashley Adams | Female | White |
Marketing | James Jungle | Male | Hispanic or Latino |
HR | Laura Log | Female | White |
Client | Jeff Jingle | Male | Asian |
Events | Alyssa Apple | Female | Hispanic or Latino |
Fashion | Flore Flam | Female | Decline |
Example B
Row Labels | Female | Male | Not declared | (blank) | Grand Total | Female | Male | Amer Indian | Asian | Black | Hispanic | HI or Pac Island | 2 or More | White | Decline | Blank | Total |
Clients | 5 | 5 | 0% | 100% | 0% | 40% | 0% | 0% | 0% | 0% | 0% | 60% | 0% | 100% | |||
American Indian or Alaska Native | |||||||||||||||||
Asian | 2 | 2 | |||||||||||||||
Black or African American | |||||||||||||||||
Decline to Provide | 3 | 3 | |||||||||||||||
Hispanic or Latino | |||||||||||||||||
Two or More Races | |||||||||||||||||
White | |||||||||||||||||
(blank) |