Results 1 to 5 of 5

Excel Formula to find conditional duplicate instances in a column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Lightbulb Excel Formula to find conditional duplicate instances in a column

    Hello Excel Experts,

    I am trying to find the total number of duplicate instances based on user Input.
    In the attached sample data, i have data in column A,B, C spread across 40K rows (even more). So based on category (1 input) and sub category (2 inputs), i want to find the duplicate instances of 'Item Number'. In the attached example, category is 2000, and sub category is A and D, so there is one 'Item Number' duplicated which is "AB1236", hence count will be 1.

    Can anyone please help me with the excel formulas to pull the total duplicate counts.? All are Random values in column A,B,C and nothing is standardized.

    Thanks for the help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find the duplicate from a column of a excel of text string in colm b
    By SUPERVISORPTCL in forum Excel - New Users/Basics
    Replies: 17
    Last Post: 02-25-2022, 01:04 PM
  2. [SOLVED] Formula to find entries with duplicate value in one column AND differing value in another
    By MadMaxineisMad in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-30-2021, 09:45 AM
  3. how to find the duplicate records or remove from an excel column
    By santbiju in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2016, 09:52 AM
  4. New User - How to find all instances within a column?
    By Grusvag in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-17-2016, 04:35 PM
  5. Formula to find duplicate values in one column
    By Dogmia78 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-18-2016, 04:42 PM
  6. [SOLVED] find all instances for specific value in first column
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2016, 07:57 PM
  7. [SOLVED] Find the first and last instances of a text value in a column
    By Tamarissa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-15-2015, 12:13 PM

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