Results 1 to 16 of 16

compare two cells

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    27

    compare two cells

    Column A....................................Column B
    6858 3/4 in hcs hex die.................die 1-7/16" 3/4-10nc
    20729 hex die 9/16-18nf................die 1-7/16" 9/16-18nf
    5/8 in hcs hex die.........................die 1-7/16" 5/8-18nf
    hex die 3/4-16nf............................2x4-8 SPF


    I have a spreadsheet with 17,000 lines. I want to a function that will look in A1 and see if any words in that cell match any cells in B1.



    =if("any words in A1"="anywords in B1","similar","no-match")

    Something along those lines
    Last edited by NBVC; 09-14-2011 at 12:07 PM.

Thread Information

Users Browsing this Thread

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

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