string comparison

  1. M

    UDF - Custom Split and Remove

    Hey there, I've created a custom function which compares two text strings, and removes any duplicates. For instance String 1 = "Bob; Sally; Tom; Beth;" String 2 = "Sally; Beth;" Resulting String = "Bob; Tom;" I have two issues. One is that my function is being recalculated needlessly. For...
  2. L

    VBA - Read a list item, check if it matches any previous ones - if not, write it in cell below previous, otherwise skip to next one.

    Hi guys, Currently the simple code below reads two values on a row, one from column "C" and one from column "D". It concatenates them and writes the new string in column "B". Sometimes the list in column C will contain more than one string exactly the same. I don't want it to write a value...
  3. T

    Comparing Strings with VBA code

    I have a large data set with multiple columns and a significant number of rows. Each column has a string with a number in the same place but the number is different for each column. Due to typo errors I want to compare each column to the first column, which I know is correct. Is there a way for...
  4. P

    Unifying List of Strings Using Approximate String MAtching

    Hello, I am sorry in advance if I have picked the wrong words for the title of thread (which i think is the case, since web search returned no relevant results). Basically I have a column with company names where the company names were not standardized. Meaning you will see for example...
  5. P

    String Comparison Help

    <tbody> CompanyCode CompanyCode Result 112 New York asq 442 New York abd Pass 334 San Fran wws 252 Kansas 1saq Fail 210 St.Louis qes 088 St.Louis abc Pass </tbody> Hi there, I am looking for help on creating a string for my spreadsheet. The table above is a small sample...
  6. M

    Comparing Alphanumeric Strings

    Hello Everybody, I got a simple sheet in which I got some columns of data representing certain grid-line i.e. A-25, B-35, C-41 etc and I got another column in which the data is like B-25.5, C-26.5 etc. I want to compare the both columns and know for each item that which item is bigger or...
  7. S

    String testing in VBA returns wrong result

    Hello, I am working on a function that should compare a String originalName to a list of names. I use a While loop with an if statement checking at every line of the list whether or not the content is identical to the string in argument. However, when I run the function step by step, when I...
  8. 2

    string comparison

    Hello Frieds I need some help in comparing two columns having text strings. I have two columns containing text strings (item descriptions). I am trying to compare these two description columns so that I can identify match and mismatch. In addition to that I also need to do compare the two...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top