+ Reply to Thread
Results 1 to 5 of 5

TRUE / FALSE result - ROW Duplication / Duplication in ROW

  1. #1
    Registered User
    Join Date
    09-10-2022
    Location
    Australia
    MS-Off Ver
    Microsoft 365
    Posts
    2

    TRUE / FALSE result - ROW Duplication / Duplication in ROW

    Hoping it doesn't seem too much of an ask, but I have two (2) requests for the one data set.
    The seven (7) columns has multiple ROWs with numbers in them that can't be sorted
    The numbers may vary in the ROWs
    The numbers may be duplicated in the ROWs, or in the ROW data

    Return1: Is a TRUE / FALSE result for a comparison for duplication of the selected ROW (Columns header: Example 1-7) to previous ROWs
    1 = No Duplicate ROW
    0 = Duplicate ROW

    Would like to count (i.e. = 1) the ROW if it isn't a duplicate (other COUNT / SUM etc. formula can be applied later to aggregate data etc. - not require at this point in time)
    Duplication is if the selected ROW and previous ROW/s have the same numbers even if they're in different COLUMNs

    Tried various formulas, but couldn't get them to fit. The INDEX-MATCH seemed like a win, but came unstuck with the criteria and search range, since it starts to get messy with the seven (7) columns, and the criteria is the entire ROW, not just one CELL, then there's the issue with MATCH and how it only searches in one (1) ROW / COLUMN - Plus I'm not great with ARRAY ({}) type formulas, I can copy & use VBA pretty well, but illiterate when it comes to writing it..

    Return2: Is a TRUE / FALSE result for duplication in the ROW data / in the ROW itself
    1 = No Duplicate in ROW
    0 = Duplicate in ROW

    Know how to work Conditional Formatting to locate duplication for individual ROWs; unsure how to enlarge for a wider scale (thousands of ROWs)
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,622

    Re: TRUE / FALSE result - ROW Duplication / Duplication in ROW

    For part 2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,622

    Re: TRUE / FALSE result - ROW Duplication / Duplication in ROW

    For return 1, maybe a Helper column in column P

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

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

  4. #4
    Registered User
    Join Date
    09-10-2022
    Location
    Australia
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Re: TRUE / FALSE result - ROW Duplication / Duplication in ROW

    Thank you! TMS It's exactly what I needed
    I never thought to use TRANSPOSE

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,622

    Re: TRUE / FALSE result - ROW Duplication / Duplication in ROW

    You're welcome.

+ 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. [SOLVED] help with IF function returning a false result instead of a true result
    By Souled in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-22-2021, 05:08 AM
  2. [SOLVED] Row Duplication based on Cell <>"" in Clumn +1 = TRUE
    By nhoj in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-30-2018, 10:07 AM
  3. [SOLVED] How to Avoid Duplication in Vlookup Result?
    By siroopm in forum Excel General
    Replies: 4
    Last Post: 12-31-2017, 01:53 PM
  4. [SOLVED] If the IF function result is false then check the next cell until get a true result
    By Beag air Bheag in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-10-2017, 08:55 AM
  5. Help - Need To Add Borderline Dependant On Result/Duplication
    By TkdKidSnake in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-18-2015, 03:03 PM
  6. Replies: 1
    Last Post: 05-09-2014, 04:26 AM
  7. [SOLVED] Index/Match/Large Duplication of items; not returning true values
    By Darren_Rix in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2013, 07:27 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