strawberry

Hi all, This is taken from a previously asked question but that allowed VBa. In this case I am trying to do it via formula and not use multiple columns to get the result. IE only the cell in "C" has a formula. This should keep all guru's busy for awhile :laugh: I sure as heck have not got far...

Hi! I'm trying to figure out a smart way of comparing text strings in two columns and returning the values that are unique for column B in column C. The order of the values is random and superfluous commas and spaces need to be removed (no commas occur within the individual values). All help is...

Hello everyone , Suppose there is an excel page that I don't want instead of searching for and deleting it manually. Is there a method to delete that page that if it contains a specific (Word) on it? For example, Page 1 : strawberry juice is written inside it , If i have to locate it among...

<tbody> Current Text (A) Desired Lookup Result (B) green apple apple red apple apple brown banana banana yellow banana banana yellow strawberry strawberry red strawberry strawberry </tbody> Column A contains extended text with the key word. I want to return the key word in column...

Hi Guys, Need help with the below. So I need to copy the whole row of those crops that have changes in length from day 1 to day 2. The below is just an example, true data contains many rows and columns. I don't want to add another column that will check if day 1 and day 2 are the same. What...

Hi, I need a VLOOKUP which will give me a result if the text in a column is found in another column even if this text is contained inside a word. So if I have: A...... B...... C apple apple apple pear...