string compare

  1. J

    Writing a Regex Macro that - stores matches , compares matches , and merges exact and similar values

    (?<word> \w{4,}) This is a php code that does exactly what I want my macro to do. String together characters a-z and 0-9 (not case sensitive) and match words when they are equal to or greater than 4 characters. I am not sure how to get this code into VBA's language. I need it to loop through a...
  2. R

    Excel VBA Comparing 2 Alphanumeric Strings

    I've written some code to compare two strings in the same worksheet. The code should check to see if the string in column b appears anywhere in column a. If the string is present in column a then a value of 'yes' should be returned. If the string isn't present then 'no' should be returned. An...
  3. K

    matching strings

    how can i check if a2 string is a sub string of b2 so if a2 is "Apple And pears" and b2 is " bananna Apple And pears" this is a match but if b2 is "Apple" should be false as it does not contain the full string of a2
  4. H

    Excel Encoding Comparrisons

    Hello - I have been having an issue comparing strings in excel because they are encoded different. I am pulling data from a database with the collation type utf8_general_ci and trying to compare it to another string pulled from the data in the excel sheet. The comparison statement always...
  5. S

    Need help in Excel Macro (To Compare and copy text from a cell to another workbook)

    Hi, Straight away i am going to the problem. I have three excel workbooks (Trans, Work and Missing). 'Trans' workbook contains English text ant its equivalent French translation. Work contains the some blah blah stories in each cell of column I,J and K. In the cells of 'work' workbook, some...
  6. D

    Comparing Strings

    Hi All, Been grappling with this for a while - thought I had it solved before christmas but on revisiting, does not produce the reusult i need. I have the following working code which looks at a range (containing strings of text and mumbers with 3 letters followed by a number eg AAA1, BBB5...
  7. R

    An Elegant Solution must exist!

    Hello everyone, this is my first post to the board I've got an excel question that is a real humdinger. One of my spreadsheets has a list of which hotels people have stayed in: <TABLE style="WIDTH: 258pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=344...
  8. E

    Binary Search and String Order Position

    Hey, I'm hoping someone has a quick fix for this situation. I have a macro that renames specific named range names from a list. In the spreadsheets I run this against, there may be 10,000+ named ranges so it takes way too long to search my Named range Variant to locate the one to change. In...
  9. F

    VB IF Statement dependant on contents of Cell

    Hi Experts, I am attempting to write an if statement that will read the contents of a cell, and based on this act appropriately. Is this possible? It only needs to look for two conditions, so as follows: If cell C4 Contains the word "evening" ( D5 = 5 + 2 ) Else If cell C4 Contains...
  10. P

    match with array in first argument?

    Greetings I have two tables that I'm trying to pass information from one to the other - Table A - ShortName CustNumber ABC 123 DEF 543 HIJL 443 ... ... Table B - LongName Amount CustNumber DEF Incorporated $343...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top