toyota

Hello All, Here is the sample DATA in range (B2:B10) <colgroup><col></colgroup><tbody> Toyota Suzuki Suzuki Yamaha Toyota Toyota Suzuki Ducati Ducati </tbody> I want formula in Range (A2:A10) I am using this formula in cell A2 to return 1 if the condition is met...

Hi, I have a document with different sheets named year (215,2016, etc). Each sheetcontain data from car manufacturers. Fo example: Sheet A (2015) AUDI BMW Toyota Ford Volvo Volvo Sheet B (2016) BMW Citroen BMW BMW AUDI In each sheet, a manufacturer can be stated several times. I need...

My Loaded sheet in the power query has data given as input in the below example I need formula to convert the data to another sheet by removing any thing other than alphabet from a cell and display it Note : The input might contain Number, Special character or spaces before the actual text...

Hi There, Greeting! I would like to combine the column R data in column s where the Last word mentioned. Is this possible? I would like combine all subset column R values in Column S of Last word mentioned beside cell...

Hello Team! I have a table that contains Products and parts for manufacturing(sheet1) <tbody> Part Number Part Name TOYOTA 374F TOYOTA 637F NISSAN 1224 VOLVO 2650 HU294150-0400 CYLINDER 1 1 HU294150-0410 CYLINDER 1 1 HU294191-0100 CAMSHFT 1 1 1 HU294191-0070 CAMSHAT 1...

<tbody> ID Part number Kind manf. date comments 300 100 L 09/05/2001 toyota 300 101 R 06/03/2001 toyota 301 200 L 01/01/2015 Honda 301 201 R 01/01/2015 Honda 302 300 L 01/03/2012 Nissan 302 301 R 01/05/2014 Nissan </tbody> After merging...

Hi, Is there a way using VBA to have an auto-correct or suggested correction for misspelled words? Like below if I have these in Column A: <tbody> toyota tayota tyota nissann nisan nssan nissan </tbody> Then the auto-correct or suggested word will be placed in Column B. Above is just...

I need to add a link and open a file by entering a textstring in another cell. Is it possible to achieve that? Or, following the below example, maybe 5 macros to do that job better? A simplified example of what I am trying to achieve would be: I have five Power Point files stored in a folder...