comma delimited

<tbody> Date Reason 1/25/2015 red 1/25/2015 blue, red 1/26/2015 green, blue 1/26/2015 blue 1/26/2015 red 1/27/2015 green, red 1/27/2015 red, green </tbody> Hello, I have a table with comma delimited data in the cells. I need to count the number of unique items in...

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, I am trying to execute a script I copied from this site to transpose a column of values into unique rows. There was a very similar thread to my question, but the code does not work for my situation as I am a newbie to VBA. The referenced thread was...

I would be very appreciative of anyone's help on this. Here is what I am trying to do: I have a column for reporting meeting dates for each entity. So a cell may contain numerous dates. For example: <tbody> Entity Meeting Date Entity#1 5/1/13, 4/10/13, 11/10/12, 9/14/13 Entity#2...

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...

I have two sheets. First sheet (Data) contains data of all the SKUs that i carry in my store. Second sheet (Output) should organize by StyleID and output all Color and Default Image associated with StyleID. Multiple values of Color and Default Image need to be outputted as comma delimited...

Trying to enter a sumif for a column that contains comma separated. colB = "Florida, Tampa"...I need to sumif for Tampa. So, sumif colE when it finds Tamps in colB. Any ideas? Thanks.

I used this formula to insert a comma after the first text in a column (last name in this case), =REPLACE(C2,FIND(" ",C2),0,",") and worked like a charm. Now I need to separate the last name and first name in to two columns, but the column with the new commas is actually full of the formula...

Hi everyone, I would've thought this was a simple enough question but I've been searching online for an answer all week, including on this site. I've seen answers that seem to be close to what I'm looking for but when I attempt to extrapolate and modify the code I get nothing but error...

If I have the following data in two columns, I need VBA code that creates a new table that finds the data associated with A,B, or C and then lists it as comma delimited text -- It's kind of like a sumif in Excel except that instead of adding numerical values, I need to create a list of text...

I am working with a .CSV file that is generated upstream from me. It contains 1500 rows of data, each row has 6 columns. The first column is "Company Name", followed by three columns of dates and then some performance numbers. The problem I am having is that the file is comma delimited and...

I have a section of my sheet that allows the user to put in household member names, one member to a row. (In the other columns in each row they enter the members' demographic info.) How can I turn a VARIABLE number of rows of names into a list in a different part of the sheet? So for example...