string comparison

Hello all, I am a newbie with excel, so I'm hoping someone can help out. in the workbook I'm working on, I have multiple tabs with data spread out. Tab 1 contains a list of resources and the dates they will end support. Unfortunately, some list the full name, and others list just the first...

Hello friends, I have a question about finding the word "pear" in a string I need to write the result in column C ... In column A there is fruit with "Pear" Column B contains other fruit, but also "Pear" If there is a pear in column B, then write the result without "Pear" in column C. The...

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

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

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

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

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

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

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

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