+ Reply to Thread
Results 1 to 2 of 2

find duplicates and replace

  1. #1
    Registered User
    Join Date
    07-20-2018
    Location
    Noida
    MS-Off Ver
    2010
    Posts
    1

    find duplicates and replace

    I have two sheets one from our purchase deptt. and second from Govt. website .

    I want to reconcile and find duplicates in a pair.

    For example :-

    1 Duplicate 7
    2 Unique 8
    3 Duplicate 6
    3 Duplicate 4
    5 Unique 11
    6 Duplicate 3
    7 Duplicate 9
    8 Duplicate 1
    9 Duplicate 1
    10 Duplicate 10

    here i want the second 3 in first column to show unique because it does not have a pair in column 2. because these column are amounts and i want to find the missing funds. also i want to find an approximate rounded off value.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,160

    Re: find duplicates and replace

    Hi,

    This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

    This formula in D2 copied down will identify the unique values
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    but I've no idea what you mean by 'find an approximate rounded value'

    Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Replies: 3
    Last Post: 11-25-2014, 06:08 AM
  2. Find duplicates in column B, keep value from first instance in A, and replace B:H
    By votekinky06 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-31-2014, 04:04 PM
  3. [SOLVED] Find and Replace on some duplicates in a huge data file
    By Vaslo in forum Excel General
    Replies: 3
    Last Post: 03-06-2014, 01:22 PM
  4. [SOLVED] Macro to find duplicates, concatenate Unique Values, then delete old duplicates
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2013, 04:32 PM
  5. find in excel replace in word: find/replace text in text boxes and headers
    By dean.rogers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2012, 12:40 PM
  6. Replies: 1
    Last Post: 07-13-2010, 10:09 AM
  7. Generate GUID, Find Duplicates, Replace, Rescan
    By talkinggoat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2010, 03:29 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