concantenate

I have the below spreadsheet data that I need to determine if there are duplicate values in column A, if there are, then the values in column B (where a match exists) should be concatenated together and the duplicate row deleted. Note: the data that needs to be checked for duplicates does not...

I've got this nagging situation/s. In my excel files I've this: examples in the tables are as below: Names FirstName MiddleName LastName Roberto Engelesias Darwin Subramurthy s/o Thirumurthy Abdool Kassim ibnu Murshid Azmi Bin Abdullah How do I seperate it into...

Hi everyone, Super new to writing VBA code. I'm trying to set up a rudimentary document control numbering system. 2 sheets in the workbook, "Doc List" & "Options". I have applied the offset formula for the items under names, and assigned them to names. These are: Author_Name; Discipline...

I'm not even sure where to start with this one. I have the following scenerio: <tbody> A B Seattle Supply Works 123 Seattle Supply Works Main Street Seattle Supply Works Kent, WA 98032 Levittontown DC cc Property Mgmt Levittontown DC 456 Levittontown DC East Main Street...

Hi, I have a summary table similar to the one below. The worksheet has column headers with multiple criteria consolidating into the single row criteria. <tbody> FCST Actual October October 2017 2017 Account 1 Account 2 Account 3 Account 4 </tbody> The data is located...

How do I use the below formula to output a percentage of F10 instead of a decimal? Also, is there a way to automatically make it + or - depending on an increase or ad decrease of growth?

We have a very long list exported from our system that has multiple lines of descriptions with the same invoice number. We need to merge this so we can merge it with another file.

Let me try to explain this better then I did with the title. I am using a concatenate formula to take information from other cells and create an address block in one cell (Client Name, Client Company, Street Address, City, State, Zip, and Country). Right now they always put the country in the...

Hi, I am trying to run a cross-check in Excel 2010 between two different sets of data and I am having issues getting the (IFERROR(VLOOKUP)) function to work properly. Because the data in both spreadsheets has different names for the same thing (i.g one spreadsheet uses the term "YSCINT" and...

I would like to use an IF statement that will insert "No Comments Added" string where the concatenated cell is empty. Is this possible? I need to stream line some worksheet process building reports for management. I only have one stumbling block left regarding the following formula...

Hello, I need to concantenate anywhere from two to N cells per row where N is the number of headers in an Array I populate. Also the columns per project move about so I need to use header names instead of Column Numbers. Also I am using Arrays becuse I can have upword of 400,000 rows and...

Hello all, Thanks in advance for your help. But I have a predicament. I need to report back cell in Column1 = all instances of Column4 based on the match made between Column2 & Column3. Columns 1&2 are directly 1:1. Columns 3&4 are also 1:1. Columns 2&3 will have multiples of the same...

Is it possible to use a formula to lookup and arrange data in a certain order. For example if you had: 1 acorn drive 5 temple avenue 3 acorn drive 4 acorn drive 7 acorn drive etc to be displayed as 1,3,4,7 acorn drive 5 temple avenue? is have looked everywhere but don't know if it is even...

Hello! I am creating an excel spreadsheet that will update numbers based product id and product type. i identify the column by concantenating both into a new cell which is my index. currently i have VBA primed to add more columns but i have trouble with this one little piece. testval =...

Hello, I have struggled with this one and I am not a coder, was looking for some code or assistance. I have 2 columns: A1 Shirt B1 Blue A2 Jumper B2 Red A3 Socks B3 Green A4 Hat B4 White I want it to go to the first line in A1 and then combine with every...

HI Here's my challenge: #1 - Digits must retain 4 digit value #2 - I need to merge them into one row separated by semicolon ";" <COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> 0028 0298 0357 0387 0524 </TBODY> DESIRED GOAL - 0028;00298;0357;0387;0524 How do I do this w/out use...