concatanate

Hi everyone! New user and novice excel user here trying to figure our a solution to a problem. I included a video instead of typing out the question here because it's kind of complicated with the concatenate functions that I'm using. The end-goal of what I'm trying to accomplish is based on a...

Good afternoon all. Have a tricky goal to try and combine two rows with the same data, so merge it into one row of data. I will need a formula that can combine them as ill have lots of this data coming in. As you can see below - A, B and C all share the same data and i need them merged into...

Hi, First of all, my level of VBA knowledge is hacking together things I find on the internet, so I apolgise if this is a stupid question. I have the following table (made up details, but same format): Server Patch No Date Server 1 1 27/04/22 Server 1 2 27/04/22 Server 1 3 27/04/22...

Hi all, I'm quite new no VBA, so trying to find my way here. What I am trying to do is to copy a row of data from seperate Excel workbooks, located in different folders into one master sheet. So what this looks like is that I have the following files in these locations...

Hello, I'm working in Excel 2016, unfortunately this can't be updated due to work. In column A I'm trying to get the cells to read off the question numbers of the first 6 incorrect questions and column B the corresponding MW clips that go with each of those first 6 incorrect questions. Any...

I run a report that displays a list of employees with all the information associated with their employment record. One of the things on there is a concatenated list of all their Employee Roles, with a Valid To and From date. For example, if the list of possible Roles is as follows: Role 1 Role...

Good morning all, I wanted to concatenate colors (in range B) with respect to each value which is in row A. (see image) . The result is in Range C. I used concatenation with condition like this: = IF (A2 <> 0; CONCATENATE (B2; ","; B3; ","; B4; ","; B5; ","; B6); "" ) because sometimes there...

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

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

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

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

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

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

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

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