Results 1 to 8 of 8

Identify Duplicates and Non-Duplicates within an Array (Match)

Threaded View

simpson11 Identify Duplicates and... 02-23-2013, 02:17 PM
BB1972 Re: Identify Duplicates and... 02-23-2013, 05:27 PM
simpson11 Re: Identify Duplicates and... 02-23-2013, 06:16 PM
BB1972 Re: Identify Duplicates and... 02-24-2013, 10:04 AM
simpson11 Re: Identify Duplicates and... 02-25-2013, 11:18 AM
BB1972 Re: Identify Duplicates and... 02-25-2013, 05:08 PM
simpson11 Re: Identify Duplicates and... 02-25-2013, 05:54 PM
BB1972 Re: Identify Duplicates and... 02-26-2013, 09:49 AM
  1. #1
    Registered User
    Join Date
    09-19-2012
    Location
    Connecticut
    MS-Off Ver
    Excel 2010
    Posts
    6

    Identify Duplicates and Non-Duplicates within an Array (Match)

    Hi,

    I am trying to identify a specific non-duplicate value in a list with a variable range within the list. What I need the formula to do is look for "Y", until it finds a "N", then identify the duplicate(s) "Y" in that identified range. Following a "N", when another "Y" has been identified, I need the formula to again look for duplicates in then next range.

    I tried the array formula below, but it counts the number of "Y" and I need the very first "Y" in each "range within a range" to be identified as the first "Y" (or identified as a non-duplicate).

    =IF(COUNTIF(A1:A30,"N"),COUNTIF(A1:INDEX(A1:A30,MATCH(TRUE,A1:A30="N",0)),"Y"),COUNTIF(A1:A30,"Y"))

    In the example below, I would like the first "Y" to be identified as a non-duplicate, the next two "Y" can be either counted or can show as a single number (ex. 1 = duplicate within the range, 0 = non-duplicate). "N" does not necessarily need to be distinguished from "Y", as I believe I can use an if(and statement to separate the "Y" and "N" in another column.

    Y 0
    Y 1
    Y 2
    N -
    Y 0
    N -

    Thank you in advance,

    Jared
    Last edited by simpson11; 02-25-2013 at 05:58 PM. Reason: Problem Solved

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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