comma-separated data

Hello! A set of data was gathered where it consists of name of certifications and those who have completed such certifications. Required certifications (certs to shorten) needs to have a 'Yes' filled out . What I'm trying to figure out is returning a list of what certs that are required against...

Greetings everyone, and thank you in advance for guidance and help resolving my challenging issue. Two things that I'm not knowing how to do. vlookup is only bringing back the first item. and secondly how to add results to the same cell. my goal is this. On my second tab "vlookup results"...

<tbody> 1 <colgroup><col width="64"></colgroup><tbody> 1, 5, 9, 13, 17, 21, 25, 29 </tbody> 2 <colgroup><col width="64"></colgroup><tbody> 2, 6, 10, 14, 18, 22, 26, 30 </tbody> 3 <colgroup><col width="64"></colgroup><tbody> 3, 7, 11, 15, 19, 23, 27...

To All, I have an excel spreadsheet with a project column and columns for each month of the year. On a different tab on the same spreadsheet, tab name = JIRA. For example: Main Tab: Project(Column L) Jan hours Feb hours P1 P2 JIRA tab Project (col B) Jan hours (Col J) FEB hours (Col...

Hi Guys, I download an excel file of survey answers on a monthly basis for a report. Each line item is an unique entry. For a particular questions (multiple select): example: Which fruits do you eat: A / B / C It puts all the answers into 1 cell separated by commas. Example "A, C" or "A" or...

Hi, A sample spreadsheet of what I have is provided below: <tbody> ID NUMBER CHEMICAL NAME HAZARD VALUE 1 chemical a carcinogen recognized 1 chemical a Respiratory, blood, kidney suspected 2 chemical b immunotoxic, carcinogen suspected 3 chemical c liver, carcinogen recognized 4...

Hi there, I have a data set containing the numbers 1-8 with each representing a particular variable. I would like to determine the frequency of each variable. I can do this if there is only one variable in each cell. However, some cells contain multiple variables separated by a comma. For...