Results 1 to 9 of 9

Complicated IF function

Threaded View

Nickopopolo Complicated IF function 05-21-2016, 05:08 PM
TMS Re: Complicated IF function 05-21-2016, 05:47 PM
Nickopopolo Re: Complicated IF function 05-21-2016, 05:57 PM
TMS Re: Complicated IF function 05-21-2016, 06:04 PM
Crooza Re: Complicated IF function 05-21-2016, 06:03 PM
TMS Re: Complicated IF function 05-21-2016, 06:07 PM
Nickopopolo Re: Complicated IF function 05-21-2016, 06:16 PM
Crooza Re: Complicated IF function 05-21-2016, 06:22 PM
TMS Re: Complicated IF function 05-21-2016, 06:39 PM
  1. #1
    Registered User
    Join Date
    05-21-2016
    Location
    Exeter, England
    MS-Off Ver
    2013
    Posts
    35

    Complicated IF function

    Hi guys, it's me again!

    I have a little complication, here how it goes:

    I have 1000+ train routes. Previously, with the help of a certain forum member we were able to determine the starting point and end point of each route.

    Now I need to check for duplicates in a following way (please see the screenshot):
    IF cell B2 EQUALS any cell in column B (besides it's own obviously) OR any cell in column C (again, besides it's own) AND cell C EQUALS any cell in column B (besides it's own obviously) OR any cell in column C (again, besides it's own); if true - then "Yes"; if false - then "No"

    As you can see, I know what I want to achieve but I simply don't know the right combo

    Really hope someone will be kind enough to help

    I attached a spreadsheet as well for your convenience

    All the best,
    Nick
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need Help ( Complicated IF function - Maybe- )
    By afzalzada in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-21-2015, 06:15 AM
  2. [SOLVED] Complicated IF function...
    By Janderie in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-17-2015, 08:45 PM
  3. Complicated IF function with example
    By ruthyeh in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-21-2013, 06:40 PM
  4. Complicated IF function
    By ruthyeh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-21-2013, 10:59 AM
  5. Help with a complicated IF function
    By este994 in forum Excel General
    Replies: 17
    Last Post: 04-20-2011, 07:10 AM
  6. A Complicated Look up Function?
    By screamnyak in forum Excel General
    Replies: 2
    Last Post: 02-24-2011, 01:01 PM
  7. Complicated function; Can it be done?
    By The Boy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-30-2007, 08:10 AM

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