+ Reply to Thread
Results 1 to 4 of 4

detecting duplicate values in a column (values are made of formula)

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    Yuen Long, Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post detecting duplicate values in a column (values are made of formula)

    Hi, it is my first time to consult programming tips on this site as I was having a hard time to look for the solutions over the internet. My problem is, using vba, how can I show a msgbox stating there is a duplicate value on that particular column?

    My table shows like this:

    ExcelVisualAid.jpg

    If I enter again "ec" on Agency Code and "3354" on Record No., the Maid No. (concatenated value) would be the same, Excel MsgBox should prompt me that there is already the same value generated and after I press OK button, Excel will undo/delete whatever I have entered on column H & I

    Thanks in advance for everyone who can help me.
    Last edited by louiemangaring; 08-12-2015 at 12:32 AM. Reason: uploaded visual/image aid

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: detecting duplicate values in a column (values are made of formula)

    Try this
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    01-09-2014
    Location
    Yuen Long, Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: detecting duplicate values in a column (values are made of formula)

    Man, this is great. so helpful. Many thanks bro! I hope this thread can be of help also to others.

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: detecting duplicate values in a column (values are made of formula)

    You're welcome.
    Thanks for the feedback and for the rep. points

+ 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: 1
    Last Post: 01-23-2014, 11:18 PM
  2. Replies: 7
    Last Post: 12-07-2013, 02:33 PM
  3. [SOLVED] Need to Merege Duplicate Row Values With Varying Column Values into one Row
    By LoveUsingExcel in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-01-2013, 12:26 PM
  4. Highlighting duplicate cells based on values in the new entry being made
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2013, 02:06 PM
  5. Create a row (or column) of non-duplicate values from a column containing duplicate values
    By 777volkov777 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2013, 11:11 AM
  6. [SOLVED] Need Urgent help on Adjacent values of Duplicate column values should be be in single row.
    By anto_01 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2012, 09:55 PM
  7. Handling duplicate values into unique and sum their next column values
    By No_feelings in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2012, 05:12 PM
  8. Replies: 2
    Last Post: 02-20-2012, 06:06 PM

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