+ Reply to Thread
Results 1 to 2 of 2

i am trying find repeated values in the column but it is finding only one repeated values

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    i am trying find repeated values in the column but it is finding only one repeated values

    i am trying to find repeated values in the column if found it become marked color(yellow)

    but it is only searching single repeated value

    please help

    i have attached my file


    this macro code

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: i am trying find repeated values in the column but it is finding only one repeated val

    That work only after active cell.
    This will work for all range you select.
    Select range and run SER2

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by zbor; 10-11-2014 at 06:28 AM.

+ 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] Append data to repeated values with a fixed array to be repeated on value change
    By anchuri_chaitanya in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-06-2011, 12:30 AM
  2. Replies: 13
    Last Post: 07-07-2010, 10:16 AM
  3. [SOLVED] create list of unique values from a column with repeated values?
    By Chad Schaben in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. [SOLVED] create list of unique values from a column with repeated values?
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  5. create list of unique values from a column with repeated values?
    By Chad Schaben in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03: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