contains in

Hi, Newbie need some help, <tbody> EXTRAS Colour <colgroup><col></colgroup><tbody> 2x25002770, 1xPAD, 1xWindow, 2xInso </tbody> <tbody> Slate Grey </tbody> 1x25005100, 1x25002770, 1xPAD, 1xMotor, 1xWindow <tbody> Mountain Blue </tbody> <tbody> 2x46004100, 2xMotor...

Hi All, I am new of this Forum. I have problem how to skip the row if "SEQ" column has any character instead of a number as below <colgroup><col span="3"><col><col><col><col><col><col span="3"><col><col><col><col><col><col></colgroup><tbody> SEQ INI BSB DEBIT BSB DEBIT ACC NO. CREDIT BSB...

Hi, I'm struggling with the final part to a spreadsheet. Can't work out how to upload the file so hopefully this will make sense. On sheet1: <tbody> Column A Column B IFT PSTN Fault Down 40mbps Up 10mbps IFT Fault found at Line. Please check Sync AB Fault found at Line. Please check...

Hello everyone, first time posting here. I'm trying to retrieve information from a table like the one below as such: <tbody> A B C(function) C(outcome) 1 a Harry =IF(A1="a","YES","NO") YES 2 ab Ron =IF(A2="a","YES","NO") NO </tbody> Basically if a cell in column A contains "a" I want...

I have found the formula below which half applies to my problem. This displays the correct word, depending on whether cell A1 contains that exact text only (cat, dog or mouse). =VLOOKUP(A1, {"Cat","Purrs";"Dog","Barks";"Mouse","Squeaks"},2,0) However I want it to display purrs, barks or...

I have two lists, one considered the "master," one the "duplicate." I am looking to search the contents of the master against the duplicate to see if any of entries of the master contain the entries (keywords) of the duplicate. I would like to have it display as a positive if the master list...