+ Reply to Thread
Results 1 to 3 of 3

Dupe Checking

  1. #1
    Registered User
    Join Date
    01-03-2019
    Location
    Nassau, Bahamas
    MS-Off Ver
    365
    Posts
    8

    Dupe Checking

    Have to run a check against a list of numbers and only count the ones that aren't dupes and the first one of the dupes.
    So far I've broken it into a few formulas, but I'm guessing due to the first one, these aren't showing up as numbers to sum, only count.

    Here are the formulas
    Please Login or Register  to view this content.
    Then
    Please Login or Register  to view this content.
    This, in my mind, would have let me get the sum. Unfortunately, only Count is showing up, even in tables.

    image_2022-06-29_123812710.png

    Is there a way I can get this to change and allow the sum? I've already tried converting it to numbers with no go.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,000

    Re: Dupe Checking

    One way:

    =COUNTA(UNIQUE(FILTER(Table1[Value],Table1[Value]<>"")))
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Dupe Checking

    Hi Tutsumi,

    I think a Unique() function will help with this question. See the attached where I've created some random numbers and counted the unique ones and the Duplicates. Hopes this gets close to the answer you need.
    Count non Dups and first Dup using Unique.xlsm
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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] Quick Dupe Check
    By jomili in forum Excel General
    Replies: 9
    Last Post: 12-04-2018, 03:08 PM
  2. De Dupe Macro Deleting Row With Blank Cell
    By timbo1957 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2012, 11:02 AM
  3. Deletion of dupe entries
    By dnyankardore in forum Excel General
    Replies: 1
    Last Post: 04-15-2011, 01:16 PM
  4. Deletion of dupe entries
    By dnyankardore in forum Excel General
    Replies: 1
    Last Post: 04-15-2011, 01:13 PM
  5. delete dupe addresses????
    By Curalice in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2007, 07:42 AM
  6. Clickable links & How to de-dupe?
    By tvdinner in forum Excel General
    Replies: 2
    Last Post: 10-31-2006, 11:42 AM
  7. [SOLVED] Dupe check over more than one column
    By Wynn in forum Excel General
    Replies: 3
    Last Post: 06-16-2005, 10:05 PM

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