+ Reply to Thread
Results 1 to 7 of 7

Excel duplicate files finder

Hybrid View

migindya Excel duplicate files finder 02-19-2010, 03:05 PM
JBeaucaire Re: Excel duplicate files... 02-19-2010, 03:35 PM
migindya Re: Excel duplicate files... 02-19-2010, 03:56 PM
JBeaucaire Re: Excel duplicate files... 02-19-2010, 04:11 PM
JBeaucaire Re: Excel duplicate files... 02-19-2010, 05:23 PM
ravishankar Re: Excel duplicate files... 02-20-2010, 12:32 PM
royUK Re: Excel duplicate files... 02-20-2010, 12:38 PM
  1. #1
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel duplicate files finder

    If you can describe fully how you are manually doing the comparison and deciding which file belongs to which group, then a macro should be able to sort through the folder and do the same comparison for you much faster.

    For instance...

    GROUP A always has "DogFood" in cell A1

    You say the headers are the same in ALL files, so that won't work. But you are managing to tell which file belongs to which group somehow...so if you illustrate all four group characteristics, it can be done.

    Also, what do you want done after each file is identified as one group. Specifically, what is the end goal?
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  2. #2
    Registered User
    Join Date
    02-19-2010
    Location
    Indore, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Excel duplicate files finder

    That is correct. We are somewhow managing to find the differences. Let describe the file structures:
    a. All the files consist of 6 columns (product, description, price, discounts, date available and store available)
    b. There are about 200 rows (that means there are 200 products listed in each row)
    c. The difference in these groups of files can occur anywhere in the product column, price column or discount column.
    d. We pick up two files (say A and B); paste file B's contents below those in A; then run ASAP utilities (duplicate / unique records finder)
    e. If ASAP utilities report everything to be duplicate, we assign B to group A
    f. If ASAP utilities report difference(s) between A and B contents, we assign file B to group B
    g. Then we pick up file C and repeat this procedure - twice if A and B HAD BEEN identified different from each other. Now file C can go to group A, or group B or make its own group C. Now that we know there will be only four groups, files E onwards will have to be compared to A, B, C and D.
    And we are definitely not proud of this donkey work.
    We tried some 'duplicate file finders' in the market, but none could really report precisely.
    It takes 3-4 staff members eating up 2-3 hours for this otherwise innocuous looking stuff.

    Arvind

+ Reply to Thread

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