concatanate

  1. K

    Concatenate with rows and primary key type scenario?

    I have a range of participants who all have unique identification numbers and they have taken multiple speaking series classes. These classes are listed on an excel worksheet with different rows. I want to concatenate them all together using the primary key as the unique identifier so that they...
  2. Y

    Merge data from multiple cell with the conditiion that only if the cell has data in it as well as add HTML list element

    <tbody> </tbody> This is working fine. =CONCATENATE( IF(E5<>"", ""&$E$3&CHAR(160)&$E$4&CHAR(160)&E5&" ",""), IF(F5<>"",""&$F$3&CHAR(160)&$F$4&CHAR(160)&F5&"...
  3. Q

    Formula to Concatenate Unique Values into 1 cell

    Hi there, I have some major limitations of not being able to run macros from Excel and was wondering if it was possible to use a formula for the below instead? From: https://www.extendoffice.com/documents/excel/3418-excel-concatenate-unique-values.html <code class="vb keyword"...
  4. V

    Multiple condition Situation

    Hi all. This is a rather complex situation hopefully someone will be able to help. I have 3 drop down menus as below. Cell A1 -Cell with numbers in 50cm increments from 100 to 1000 Cell B1 - Cell with drop down menu which includes 3 types of rails. Cell C1 - Cell with drop down menu which...
  5. K

    Force formula built via concatenation to calculate

    Just like the title says. I have a COUNTIFS formula I built in pieces and glued together using cell concatenation. The formula works just fine, but I need to click into each individual cell, and hit enter, for it to calculate. I have 16K cells. How do I force XL to look at it as a formula and...
  6. M

    2 sperate Font sizes in the same cell

    Hi Im using excel 2010 can anyone help me in in creating 2 sepertate size fonts in the same cell the first font is size 128 Arial & the second font size is 20 Arial the formulas are in coulmn "E" & "F" (Vlookups from another sheet), i concatanate them with a space inbetween and word wrap so...
  7. J

    How to ignore cells while concatenating cells in Excel

    Hi. I'm trying to concat Cell A, B, and C. However, I don't want to concat the row if column A has "N". For example, below I would like to skip 4and 5 because column A has "N". ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left...
  8. P

    Modifying UDF for ConcatenateIF to ConcatenateIFS

    Good morning, I found a great UDF that concatenates a range of data based on another range meeting 1 criteria. It works perfect, but I want to add another condition to the criteria but I cant get the wording correct. Here is the UDF for the 1 condition: Function...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top