+ Reply to Thread
Results 1 to 4 of 4

If statement for scanning text

  1. #1
    Registered User
    Join Date
    02-02-2012
    Location
    NJ
    MS-Off Ver
    Excel 2003
    Posts
    5

    If statement for scanning text

    Hi All,
    I am trying to figure out a way to scan a list of text and return True or False if the text is repeated in another column. Below is an example of what I am looking to do. I tried if statements and also IsNumber(Seacrch() function and have looked all of the forum and the web with no help. As you can see below, I have text in column A that I want to see if it is repeated in the list in column C. In column B you see True next to Apple indicating that that text is in the list in column C. This is the same for Orange but since PWC is not in the list is returns False. Columns A and C I have formatted to Text and column B is formatted to General. I am using Excel 2016. I hope this makes sense to people! Anyway thanks a lot for any help you can give!

    Brian

    Capture.JPG
    Last edited by bmmcpeek; 01-17-2016 at 06:23 PM. Reason: Table wasn't showing up

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: If statement for scanning text

    in C1 copy paste below
    =IF(COUNTIF($A$1:$A$7,"*"&B1&"*")>0,TRUE,FALSE)

    change the references according to your requirement
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: If statement for scanning text

    Row\Col
    A
    B
    C
    D
    1
    Text
    Check
    List
    2
    Vera
    TRUE
    Anne B2: =COUNTIF($C$2:$C$19, A2) > 0
    3
    Yoko
    FALSE
    Barb
    4
    Dana
    TRUE
    Cara
    5
    Hana
    FALSE
    Dana
    6
    Leah
    TRUE
    Ella
    7
    Gail
    FALSE
    Fran
    8
    Sara
    TRUE
    Iris
    9
    Jane
    10
    Kate
    11
    Leah
    12
    Nina
    13
    Opal
    14
    Peri
    15
    Rene
    16
    Sara
    17
    Vera
    18
    Wren
    19
    Xana
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    02-02-2012
    Location
    NJ
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: If statement for scanning text

    Thanks for the reply's! I will check this out tonight when I get home and report back. Thanks again!

+ 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. Replies: 4
    Last Post: 11-26-2015, 09:23 AM
  2. Scanning to Excel
    By Dramlakhan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-29-2015, 11:35 PM
  3. [Excel 2010] Performance issues scanning external documents for text
    By Prejdickty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2014, 09:00 AM
  4. Bar code scanning
    By joshag in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2011, 05:19 AM
  5. Scanning text
    By demerdin in forum Excel General
    Replies: 5
    Last Post: 06-12-2010, 07:42 AM
  6. Scanning into Excel
    By zinzah in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2007, 03:52 PM
  7. Scanning down a column
    By lashio in forum Excel General
    Replies: 0
    Last Post: 02-12-2006, 03:25 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