concaatenate

Greetings Excel community, I have a set of ID's and dates which are associated to these ID's. The ID's are repeated but there are numerous dates associated with its respective ID. What I am attempting to accomplish is combining all the dates associated with the specific ID. For example, ID 123...

Hi, this is my first time so I apologize for mistakes. I have already looked all over internet and have not manage to find an answer to fit my question. I have this set of data on sheet1 And I want to concatenate the IDs, Targets and DNS based on Name and Risk on Sheet2 like this So if it...

Hello All, I have 3 columns, all using different Vlookups to find me the Internal ID of a product. I've used Vlookup against, SKU, MPN, and Vendor Code hence the 3 columns. I want to combine all 3 into 1 but first compare them. At first, I tried to use 'Concat' but if the value exists in 2...

I am struggling to get the expected output as below. Input data: Output data: In the output data - Column 2 is unique concatication of Column 2,3, and 4

Hi All Sub concatenate() Dim a As String: a = "L:\OWL\Work" Dim b As String: b = "\jobs" Dim c As String Dim d As String c = Cells(0, 3).Value d = a & c & b Worksheets("sheet 2").Cells(1, 5).Value = d End Sub

I am stuck trying to convert this dynamic formula to use the CONCATENATE function instead of the &s. I am using an Excel add-in that does not accept "&" in formulas. I have tried several times to do this myself but cannot figure out what I am doing wrong. It doesn't seem to play nicely with the...

So here is what I'm trying to accomplish. There is a number out to three decimals in column A. Date in column B (mm/dd/yyyy). Say I have this data: <tbody> 2.300 8/1/2018 2.400 9/1/2018 2.850 10/1/2018 </tbody> I want to concatenate this strings to where I get a single string of "2.33...

Hi everyone, How would I go about using min/max formulas with concatenated data? For example... I have two or more cells that are concatenated and I want to use min/max on formulas on them. There will be text as well as numerical values. "Owners" which would be text and and a "height" which...

Hello All, I am trying to use a Vlookup that when I change an option from the dropdown menu the table changes the range ( A1:A15 to A17:A24) in the source file for the tab and base file name are the same but February will change to March, then April. I am trying to use this formula pieced...

I need row 25 of my s/s to show the % complete for the columns B through G, by columns and then overall % in column H. Is there a formula that it updates every time I change an item?

Hi Friends, Trying to concatenate every 100 rows into one cell =Concatenate(C1:C100) =Concatenate(C101:C200) =Concatenate(C201:C300) and so on. I have 50K rows to concatenate/combine cells Above formula is not working. I know that VBA macro can do this task. Every time I have to specific...

I dump a large amount of data with different service dates in each column. The dates are pasted as text. In the next columns, I convert the text to dates. I then have a column to find the min and another column to find the max. There can be up to six service dates in my data. I'm trying to...

Hi. I wish to concatenate a list if it meets a specific requirement. The code that works when entering into excel worksheet looks like this...

I am trying to concatenate all the cells in a column up to the 1st cell that is empty. So in cell A1 where it says "FORMULA", this is the cell I want to have the results as "Excel is really a lot of fun." or A2+A3+A4+A5+A6+A7+A8. <tbody> A B C 1 FORMULA 2 Excel 3 is...

Hi, I am trying to get this if statement with a concat formula to work, but I keep getting the message "Sub or Function not defied." The worksheet where I am trying to get this formula to run on is titled "Report." Thank you in advance for the help. Below is the code If Range("L4") =...

For instance with: =CONCATENATE(COUNTIF($H$17:$I$50, "*SPO*")+COUNTIF($H$17:$I$50, "*Officer *"), " Enforcement Total") How do I make it come out with the count in red but the "Enforcement Total" be in black?

I have an excel sheet that has page numbers, Categories, and item numbers. I want to make almost an index of the Category then unique page numbers this is the code I am using now I need to find out were to add to remove the Dups. Function ConcatenateIf(CriteriaRange As Range, Condition As...

I need to generate a CODE with the data from two cells for a project tracker, for instance: A1 = 24-10-2016, B1 = Adam Smith, My code in cell C1 should be "AS-1024", I have created this, But, If there are duplicate values in column C like, Consider Adam Smith and Aaron Swartz both got task on...

Hi Guys In cell C16 £1298 and in Cell B16 i have £1179 In cell B17 i have a simple formula =C16-B16 which obviously provide an answer £119 But i want it to say £119 More Expensive and keep the number formatting It is currently producing 119 More Expensive stripping the number format from...

Hi. I have the following in a cell that is a text. (D+0.0625)+(L+.125)+(D+0.625). I am able to substitute D with the the value 1 and L with the value 2 to give me (1+0.0625)+(2+.125)+(1+0.625). I would like to display it as1.0625x2.125x1.0625 the formula must add the values between the...