xxx

Please, I would like to have a formula to calculate how many times the group of words in D1: D3 appears, in that order, in the range A1: A20. The formula should return 4. Thanks in advance. <tbody> A D cat cat dog dog turtle turtle aaa kkk cat dog turtle...

Hi Guys, i googled and managed to find this simple code. However, i encountered error message " Run-time error '438' : Object doesnt support this property or method". I have tried both Byname and ByID but was returned with the same error code. Below is my vba code. i have masked the web link...

Hi I am familiar with left, right and mid but am unable to get the results below in a streamlined way. I was able to convert the rows using text to columns and then do a concatenation of just the characters and do the right for 3 characters but that is quite painful and not repeatable for...

Good day Need your help as i can not figure which excel formula to apply! I have large database with different customer and Product respective of their code and name, i need to find price(repeated ones) <tbody> Customer code Product name Product code Price customer name 001 Apple 1008 2.00...

G'day, Another tricky one in my mind. I have 100 jobs multiple lines per job with the same JOBID found in column A starting in A2. I also have a description of material in Column W. Starting at W2. What I need to do is if the BLOCK is the same job ID (column a) and "Ridge300" is found in...

I've tried searching for this specific problem on here and online, with no joy. I have a bunch of projects laid out and pivoted in line with the below pivot table, showing me Hours Spent and Billable Hours for each day and then in total for the week. I would like to calculate a simple...

Need Assistance how to associate combination of Company and location to apppropriate company using the below matrix please help. <colgroup><col span="2"><col></colgroup><tbody> Grouping Matrix Group Name Company Location XXX 100 000,155,200,208,209,210,211,212,213...

Hi all Firstly thanks for everyones help previously. Greatly appreciated and helps my knowledge no end. In Range"C16" - if it contains a value i.e. - "XXX" then y screen resizes. There is code of Application.ScreenUpdating = TRUE After this, I do not want anything updated if cells C17:c20...

As you can see in the image, I am trying to merge multiple spreadsheet with the name "xx" & "xxx" into the master spreadsheet "Shipment Combine"? can someone please list their macro here. Thank you.

Hi I'm trying to improve my macro skills and create a MACRO that would calculate sum from purchase/sales made by a client in different offices. However I've encountered some issues and I'm not sure how to proceed further. Example - I've a data sheet with client name buy amount sell amount and...

Hi there I need some help! I need to know how to code if two different ranges contain different values then to execute my code... I have... If Range("A1").Value = "xxx" Then What I need Is the above, but also if A3 does NOT contain a value to execute the code, if A1 contains "XXX" and A3...

Hello, I am trying to create a macro that will remove spaces from a column, IF it starts with "3 464 xxx xxx". Our vendor has spaces in their part numbers, but our system does not use them. Externally, we have to keep the spaces, but for internal use I need to remove those spaces. I have...

Hello, I need some macro who can make from this table : <colgroup><col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:7606;width:156pt" width="208"> <col style="width:48pt" width="64" span="7"> </colgroup><tbody> 9 X xxx 1...

Hi, I have a list of postcodes in column A, carriers in column B, and their rates in column C as below. I'm looking for a for a formula to replace "XXX" under the lowest cost section to look up the postcode in the list in column A and return the applicable carrier from column B based on which...

Hi, I need some help. I have a list of information provided and I need to copy a specific range and paste it into a new sheet RC 1 xxx xxx xxxx xxx xx xxxx xx xxx xxx RC 3 xxx xxx xxxx xxx xx xxxx xx xxx xxx RC 2 xxx xxx xxxx xxx xx xxxx xx xxx xxx the 1 / 3 / 2 might not be...

Hello Guys, I have two scenarios to workout. Both are almost similar only small differences. I am using simple find and replace for this, but now i am having new issues. Please go through the following scenarios. Scenario 1 The macro should read the cell C3 and delete that value in the last...

I need help on this problem. I have a large dataset, and I need to get a count for every UNIQUE 3 Bedroom record, below. So if floor plan type = 3 Bedroom, then count the records, but only for UNIQUE unit numbers and UNIQUE property name. IE, if there are 4 unit E1001 at property xxx, that...

Hello, I try to write a macro for: 1) Opening a certain webpage in Interner Explorer 11 (I am using 64-Bit MS Excel 2016) 2) Going to specific fields within a website 3) Providing "User ID" and "Password" values 4) Clicking "Login" button I am a VBA beginner :) Thank you in advnce for any...

I would like to know how to get rid rid of th parenthesis when it is copied to word...

How do you remove blanks from an array? I want to summarize data in Columns to eventually transpose the data into rows, but can't figure out how to remove the blanks in a quick/non-manual way. The data is configured similar to the following -- with blank cells being noted with XXX: <tbody> A...