I am trying to get all the possibilities that are in the given data and how many of each. Is this possible in excel? example in the below image, there is a person that is hispanic, black, and white race. I need excel to spit out hispanic ####, asian ####, hispanic asian white #### , hispanic black white ### etc.
Capture.PNG
Bookmarks