+ Reply to Thread
Results 1 to 3 of 3

VBA - Looking for duplicate in filtered range

  1. #1
    Registered User
    Join Date
    03-10-2021
    Location
    milan
    MS-Off Ver
    2020
    Posts
    2

    VBA - Looking for duplicate in filtered range

    I want to filter my DB by the values in the first column 1 and find duplicates checking the value in column 83 (values in columns 83 for visible cells must be different).

    What I am doing wrong with my code?

    Please Login or Register  to view this content.

  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
    28,111

    Re: VBA - Looking for duplicate in filtered range

    Hi and welcome to the forum

    Difficult to tell without knowing what you expect and what the macro does.
    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

    There are better ways to identify duplicates without looping, probably using a single helper column.
    Richard Buttrey

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

  3. #3
    Registered User
    Join Date
    03-10-2021
    Location
    milan
    MS-Off Ver
    2020
    Posts
    2

    Re: VBA - Looking for duplicate in filtered range

    This is a template of my excel sheet:

    gLixj.png

    I am trying to find out the rows with the same "IDM" and same "Version".

    My solution is quite complex to solve the task because I would like to filter the rows by the "IDM" (in the first column), afterward looping through the visible rows to find rows with the same "Version".

    I hope to have been more clear.
    Last edited by Enzinaldo; 03-10-2021 at 12:01 PM.

+ 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. Flash each Uniqe Values from Filtered Duplicate
    By analystbank in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-07-2020, 01:14 AM
  2. Copy filtered data into filtered range in a separate sheet
    By vikas.trades25 in forum Excel General
    Replies: 1
    Last Post: 02-07-2019, 04:04 AM
  3. Replies: 3
    Last Post: 05-07-2017, 02:53 PM
  4. Countif without duplicate in filtered cells
    By nccwhk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-15-2016, 03:25 AM
  5. [SOLVED] Excel VBA - Issue in Naming Filtered Range on a Filtered List.
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2014, 01:17 PM
  6. Hide duplicate rows from filtered data
    By Arshmaan in forum Excel General
    Replies: 2
    Last Post: 10-28-2011, 06:37 AM
  7. Pivot Table - Duplicate Columns Filtered Differently?
    By jboysen in forum Excel General
    Replies: 1
    Last Post: 07-25-2009, 12:34 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