xxx

  1. O

    Count how many times a text group appears in a range

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

    Autofill IE form based on Excel data

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

    Character extraction help!

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

    Find Duplicate value using multiple criteria

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

    COUNTIF would solve this? Tricky one.

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

    Calculate % variance between 2 total columns in pivot table

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

    How to associate combination of company plus location to particular company

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

    vba - code to hide not carry out action if any cell in range is blank

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

    Merge other spreadsheet into master spreadsheet

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

    Data Sum Up Macro

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

    VBA - If two different ranges contain values

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

    VBA to remove spaces from specific part number string

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

    Merging table rows

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

    Lowest Cost Lookup

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

    Copy Range and Paste into new Sheet

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

    Advanced Find and Replace Required

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

    Count unique records based on multiple criteria

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

    Internet Explorer - log in to a webpage

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

    concatenation and CHAR 10 copies to word with parenthesis

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

    Removing Blanks from an Array

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

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top