join

I have an array that I am able to split and get the individual text in it, then I take each string and find match on another sheet and grab the Id in the next column. I want to take the ID that I find and re join into an array. v1 = Split(ws1.Cells(r, 7), ",")For i = 0 To UBound(v1)...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I got 2 columns B & C in these columns there is a join text I want separate them in columns E, F, G, H for that I am using the formula below the problem is that if i want to sum rows E:H why I am getting 0? Please need help</SPAN></SPAN>...

I have a table with all my Customer Orders and I'm trying to return a single record for the Earliest OrderPlaced but I cannot for the life of me return the single oldest Order Number according to the CustomerID. I have 2 tables: CustomerOrders Customers OrderNumber (pk) CustomerID (pk)...

Hi all, I'm looking to find a solution for joining (sorting and removing duplicates) multiple columns in one cell and then lookup all values in a separate table and return potential values in another cell. It would look something like this: <colgroup><col span="4"><col><col></colgroup><tbody>...

Hi experts, I have a VBA code that opens a recordset: Private Sub Form_Load() Dim qdfFillDictionaryOptional As DAO.QueryDef Dim rsFillDictionaryOptional As DAO.Recordset Set qdfFillDictionaryOptional = CurrentDb.QueryDefs("qryFillDictionaryOptional") Set...

I need to get a count of cases associated with vendors, grouped by month over a time between two dates. The month part is where I have trouble. I don't know how to make the query "count" each case number by vendor for each month. Ideally what I would get is something like Vendor Month...

Dear all, Question. I have a table with contract start dates and contract end dates. I want to cross join this in power query with a table containing all months from 1/1/2019 to 31/12/2039 which are potentially the months in which payments can be done under the contracts. Is there a way in...

Hi I have numbers in one column as below, i want them in one cell if possible as following 10,20,30,40,50,60 OR 10, 20, 30, 40, 50, 60 (space after comma) I am thinking to use copy-->paste special--> transpo, then user concatenate() function to join them with "," between them. Is that the...

Hello, I have two column A and B and want to join their value and put in column 3. I am trying to follow this algorithm for better performance. array1 = value from column A => {1,2,3,4,5} array2 = value from column B => {EA, FT, IN, EA, FT} array3 = 1 EA, 2 FT, 3 IN, 4 EA, 5 FT then column...

Hi There, I have a bi-directional join within Power Bi between 2 tables. The headcount table has 23,409 rows of data, the survey data has 165,600. Within the headcount data there is a field called Primary Segment. What I what to do is to do a count of Primary Segments where the join field is...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> 1-My data columns C:P in cells</SPAN></SPAN> 2-Predefined numbers columns R:Z</SPAN></SPAN> 3-Extract and join them in columns AB:AJ</SPAN></SPAN> Extract predefined number of characters from columns C:P (as per specified in columns R:Z) and...

Hello, I am looking for some help to combine two tables of separate data based on a single column with a 1:M relationship. I do not have power pivot, so I am defaulting to vba as the best option (unless I hear otherwise). Example: The two tables share Group as a common Key - the macro should...

I have a query that has always worked, but now does not work and I get an Overflow error. I read that it has to do with dividing by zero or null values, but when I try to remove nulls or use criteria >0 I get an error that says "Your query does not include the specified...

required formula or macro for joining column2 with column 1 1.if + sign is not there then join as it is with _ 2. if + sign is there then join after first + sign length is not fix <tbody> column 1 column 2 required AAAAAAA 6 AAAAAAA_6 AAAAAAA+BBBBBBBBBBBB 2 AAAAAAA_2+BBBBBBBBBBBB...

We have the following code as a macro to extract data from the database of ALMQC. SQLquery = " SELECT " _ & " COALESCE ( " _ & " ( tsetfold10.CF_ITEM_NAME " _ & " + '\' + tsetfold9.CF_ITEM_NAME " _ & " + '\' + tsetfold8.CF_ITEM_NAME " _ & " + '\' +...

Apologies in advance if I don't articulate this clearly. I'm not sure I understand myself exactly how to say describe it. I have 3 tables, one in each column (A-C below) I am using Power Query to do a cross join (or cartesian join - not sure the right name) and the output of that cross-join is...

I am using the below Select statement, which works fine. However, when I change the values below in Red to ? as is done in the WHERE clause toward the end of the statement in order to use parameters defined in specific cells in a worksheet, I get a "Numeric Value Out of Range" error. I do not...

I could never get pictures to save. Anyway, I have a table (Table A): https://pasteboard.co/HpTLfSL.png and another table (Table B) https://pasteboard.co/HpTLsxl.png and I want to aggregate (Table B agg): https://pasteboard.co/HpTLGFn.png I can do this in power pivot. But then I want to...

Hi, can someone help me how to join these A,B,C D columns. Sheet6 <tbody> A B C D E 1 10 15 10 am 10:15:10 AM </tbody> Excel 2007 Thanks

I keep getting error 462: The remote server does not exist or is unavailable. Any ideas? Here is my code: Public Sub SendButton_EMAIL_Click() 'Email Declarations Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem 'Set References On Error GoTo...