Results 1 to 2 of 2

Thread: Fuzzy Logic

  1. #1

    Fuzzy Logic

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Help Needed

    I would class myself as a confident user of excel but I have real got stuck with this one.

    Back ground, Two sets of data tables, identical formats however,lines will be estimated at around 250,000 per year, 6 years of data.

    What 'm trying o investigate is if we have an duplications, but we need to consider a number of options:

    1. Number ( Does it match another one by 90%+, so I the number is 10 digits long, does another number with 9 matching characters :
    a. Same Value
    b. Same Date

    2. Value (Does it match another value where
    a. Date Same

    What I'm trying to create is a duplication report, but it has to work looking at data table one, data table two, the data table one V Data Table Two.

    An advice ?


  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    You could try conditional formatting with a formula along the lines of


Posting Permissions

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