+ Reply to Thread
Results 1 to 9 of 9

if with text DOUBLE

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,428

    if with text DOUBLE

    double tyre spring
    double tyre spring
    double tyre spring
    double tyre spring
    double tyre spring
    double tyre spring
    single tyre ( skeleton )
    double tyre spring
    double tyre spring
    double tyre spring
    double tyre spring
    double tyre spring
    single tyre booster ( skeleton )
    double tyre spring
    double tyre spring
    double tyre spring ( skeleton )
    double tyre spring
    single tyre booster ( skeleton )
    double tyre spring
    double tyre spring

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,896

    Re: if with text DOUBLE

    And your question (if any) is????

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,428

    Re: if with text DOUBLE

    I have that on F2 downwards , need formula to do the following , on j2

    If it finds the word double plug 28 otherwise 26

  4. #4
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,896

    Re: if with text DOUBLE

    Clear as mud to me. perhaps post a sample sheet with some data and expected results.

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,428

    Re: if with text DOUBLE

    double tyre spring 28
    double tyre spring 28
    double tyre spring 28
    double tyre spring 28
    double tyre spring 28
    double tyre spring 28
    single tyre ( skeleton ) 26

  6. #6
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,428

    Re: if with text DOUBLE

    EXPECTED those , it is a straight case 28 or 26

  7. #7
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,896

    Re: if with text DOUBLE

    =IF(countif($a$1$a$100,$a1)>1,26,28)
    Pull down as needed

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,531

    Re: if with text DOUBLE

    Maybe
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,428

    Re: if with text DOUBLE

    Thank u works

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pasting text with double quotes
    By Bob Anderson in forum Excel General
    Replies: 12
    Last Post: 03-25-2020, 04:06 PM
  2. [SOLVED] Text trimmer double criteria
    By makinmomb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-15-2015, 03:10 PM
  3. SQL to count double quotes in a text file
    By Deutz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2015, 10:49 PM
  4. Double Click Text Box on a UserForm to Look-up Value in Another Tab
    By timtomm66 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2013, 06:33 AM
  5. Double Quotes in text with if condition
    By kishoremcp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-11-2012, 03:02 AM
  6. Double Text in Cell with Combo Box
    By ganderson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2011, 05:32 PM
  7. double quotes around text fields in .txt
    By michele@quality-computing.com in forum Excel General
    Replies: 4
    Last Post: 08-10-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1