+ Reply to Thread
Results 1 to 3 of 3

how to calculate random duplicated data

  1. #1
    Registered User
    Join Date
    06-17-2019
    Location
    Georgia, Tbilisi
    MS-Off Ver
    2016
    Posts
    9

    Exclamation how to calculate random duplicated data

    Hi guys,

    Need help... So, I receive files everyday with random data. My job is to find out duplicated numbers in the file.
    let's say... if number 10 appears 5 times in the column A B C D E I should detect it.

    The main issue is that I don't have the list of numbers which I must find and I don't know how many number I must find.

    I just receive file every day with 5 columns. each column might contain up to 1000 records and I should find duplicated numbers which repeats in these 5 columns.

    I should define numbers which are displayed more than 4 times in these 5 columns in total

    Example is in attached file
    Attached Files Attached Files
    Last edited by levaxuco; 06-13-2021 at 05:26 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: how to calculate random duplicated data

    What do you want the result to look like? Do you need a list of these duplicated values someplace? Or just highlight them?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: how to calculate random duplicated data

    If you want to use a CF to highlight...

    =COUNTIF($A$1:$E$9999,A1)>4

+ 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] delete rows contain duplicated data or non duplicated by inputbox
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-25-2020, 04:01 PM
  2. Macro shows duplicated entries but sometimes they are not duplicated due to data.
    By tweacle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2020, 04:47 PM
  3. generate n random numbers not duplicated for each id numbers with Vba
    By fatoom91 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2019, 03:31 PM
  4. Replies: 2
    Last Post: 07-19-2017, 05:36 PM
  5. [SOLVED] Calculate Count of Text in Blank Cells (Random Data)
    By a1ksingh in forum Excel General
    Replies: 3
    Last Post: 06-09-2016, 11:51 PM
  6. [SOLVED] How to calculate time difference for duplicated entries
    By mahershams in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-14-2014, 10:36 PM
  7. Non-random numbers generated by excel's data analysis random gener
    By Allie in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-17-2005, 02:05 AM

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