+ Reply to Thread
Results 1 to 3 of 3

HELP! vBa code for duplicate result

  1. #1
    Forum Contributor wedzmer's Avatar
    Join Date
    06-13-2014
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    422

    HELP! vBa code for duplicate result

    Hello everyone!

    What should be the best VBa Code for this situation...?

    I would like to check that if the display results of column B would have duplicate results then the duplicate would automatically be deleted.

    I am using vlookup formula on column B and at the end of the table in column B, it duplicates the last entry when the table range referenced is empty or something like that. I'm really not sure why... So what happens is, the last display result in B77 is valid but the B78 displays the same result with B77 even though the vlookup formula for both cells are different.

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,265

    Re: HELP! vBa code for duplicate result

    Find this could be useful:

    http://stackoverflow.com/questions/1...ponding-values

  3. #3
    Forum Contributor wedzmer's Avatar
    Join Date
    06-13-2014
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    422

    Re: HELP! vBa code for duplicate result

    Hi Azumi!

    Thank you for your response.. I saw the link already and looked at the case presented there.. Though there are similarities in the cases we have, the thing with my problem is that I needed to delete the ROW on the cells where there is a duplicate, particularly in Column B. Whereas the site was only looking to recognize the duplicates in the specified column in order to identify which ID's had the same number and not necessarily to delete the row itself.

+ 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] Vlook up to find Minimum value and maximum value if value has duplicate result
    By ryan4646 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-08-2014, 09:46 PM
  2. delete duplicate with 2 conditions (date and result)
    By owlowl2005 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-03-2014, 09:27 AM
  3. Replies: 2
    Last Post: 12-17-2013, 11:51 AM
  4. [SOLVED] Vlookup in Duplicate Result Value
    By abhinavbinkar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-25-2013, 07:51 AM
  5. Duplicate Post > Cell shows formula instead of result
    By sandeephg in forum Excel General
    Replies: 1
    Last Post: 09-27-2007, 01:33 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