comma delimited

  1. trishcollins

    vlookup on table column with cells containing multiple entries separated by commas

    I have a table that has a list of requirements from various documents. The table is called "Combined_Req". Each requirement is assigned a unique identifier "ID", that is in the form of "CR-1", "CR-2", etc." I have another table called "Req_by_Category" where I have consolidated like...
  2. I

    Add Comma in last text

    Hello, I'm wanting help with add comma in last text <tbody> Column A (Original Format) Column B (Need Add Comma at last text as below) <tbody> ECJ1VB1H562K,F1H1H562A013,F1H1H562A748,F1H1H562A219 F1H1H562A842,F1H1H562B047 </tbody> <tbody>...
  3. A

    What is the Basic Formula to Split Cells Using "Text to Columns" Option?

    Need to figure out the formula to split cells using "Text to Columns", using the "Delimited" option for Original Data Type,the "Comma" option for Delimiters, and the "General" option for Column Data Format. Or find faster way to accomplish task without clicking through it. Thanks! :):):)
  4. L

    Extract list of names into individual cells (cannot use 'text to column')

    I have a row of data from B3:B11. Each cell contains a list of names seperated by a comma. To make things more complicated though, the names are grouped by department. For example, the text in B3 looks like this: <tbody> All: John Smith, John Smith, John Smith LOB: John Smith, John Smith...
  5. L

    VBA Issue / Exporting Excel File to CSV Causing Double Quote Issues

    Hi All, My colleague and I have created some VBA code to transform a standard report into semi-colon-delimited data, all within column A, which is then imported into our financial systems (SAP). SAP only handles numerical values in European format, therefore, as part of the transformation, we...
  6. T

    Return nth term from comma delimited cell base on value of adjacent comma delimited cell.

    Hoping someone can help me with a function. I want to return the number in the left column that corresponds to “99292” in the middle column. I know I can use the “find” function to find the position of 99292 in the middle column, but that doesn’t correspond to anything meaningful in the left...
  7. G

    CommaDelimit by Join(Application.Transpose visible range

    I currently comma delimit using this and put it to the clipboard using MSForms.DataObject Dim ConvertComma ConvertComma = Join(Application.Transpose(Selection.Value), ", ") Dim clipboard As MSForms.DataObject Set clipboard = New MSForms.DataObject clipboard.SetText...
  8. M

    Generate a Cell Count Table

    Hello There, I have a big excel sheet with data in many cells across rows and columns: X Y Z X X Z T V V Z V V What i wanted to do is generate a list of cells with count as V 4 Z 3 X 3 T 1 Y 1 Can someone point me in the right direction, thanks.
  9. H

    Using SUMIF for multiple values separated by comma??

    I will have column information that will list entries like this: DD, DD9, SD, LHR, HIGHLIFT BOTTOM SECTION, DD, D9 DD, PVC DD, SD, LHR, HIGHLIFT Is there a way to run a SUMIF or other formula on these and separate the values from the commas? I am familiar with Text to Columns but I will be...
  10. J

    How to Search Comma-Separated Content in a Cell against a List

    Hello, everyone. Thanks for taking the time to read my post and to try to help. I have one column of comma delimited names (ie, "Bill, Sue, Carla-S, Dave") that I would like to search against another pair of columns -- one that has a single name per cell, and its neighboring column with an...
  11. N

    Select from Dropdown List and Concatenate Chosen Values Separated by Comma

    Hi all, I have created a table of names on Sheet 1 called 'List'. On Sheet 2, I have created columns 'Task' and 'List'. I would like to choose multiple names in the list column drop-down and have them concatenated separated by commas in the same cell or an adjacent cell. Is this possible? How...
  12. S

    Count Unique Items Per Day from Comma Delimited Cells

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

    sumif formula using multiple criteria separated by a comma(s) in one cell

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

    Need help to Transpose column into unique rows with comma delimited values

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

    Count cell if it contains a date within a range

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

    Sum frequency based on adjacent cell with separated by comma

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

    Return multiple values into one cell as comma delimited.

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

    Sumif comma delimited range

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

    inserted commas, now need to separate

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

    Write selections from Excel listbox to cell?

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top