+ Reply to Thread
Results 1 to 7 of 7

Checking for 4 duplicate values and remove columns

  1. #1
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Checking for 4 duplicate values and remove columns

    I would like to create a Macro that checkes if there is 4 times the same value in column B.
    If 4 times the same value is found than those columns should be removed. Hope this is possible

    I created a example in attachment
    Attached Files Attached Files
    Last edited by keis386; 11-15-2013 at 05:54 AM.

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Checking for 4 duplicate values and remove columns

    Should the 4 values the same be consecutive?

  3. #3
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Re: Checking for 4 duplicate values and remove columns

    Yes they are always consecutive

  4. #4
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Checking for 4 duplicate values and remove columns

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Re: Checking for 4 duplicate values and remove columns

    Thanks a lot it is working great.

    Is it also possible to add a message box that will popup and asks do you want to delete these columns yes or no
    (also with action: yes delete the columns and no do not delete the columns)

  6. #6
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Checking for 4 duplicate values and remove columns

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Re: Checking for 4 duplicate values and remove columns

    Much Appreciated for your help!!

+ 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] Remove duplicate rows by matching values across columns in Excel 2007
    By guest2013 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-15-2013, 12:00 AM
  2. excel macro to remove specific columns and rows + remove duplicate
    By garrywelson in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-17-2013, 12:03 PM
  3. Checking Cell for Duplicate Data, Same Row, Different Columns
    By aallen5642 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2011, 05:18 PM
  4. Checking column for duplicate values and appending
    By Elmer in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-11-2008, 07:25 PM
  5. Checking for Duplicate Values within a Range
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-28-2005, 11:32 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