duplicate count

  1. M

    Ranking text based on duplicate text in a column

    Hello, I have a large worksheet with 8693 rows and 69 columns and I would like to rank how many times a customers name is mentioned in a column. I'm familiar with filtering and pivot tables but my skill levels require I manually add up the customer names. I thought I could use a =RANK formula...
    • MichaelPitre
    • Thread
    • duplicate count duplicate data count duplicate values lookup rankings text
    • Replies: 2
    • Forum: Excel Questions
  2. P

    Count Duplicate Values of a Certain Cell in a Table but Only Count for One Instance in a Certain Range Within Table

    Lets use C2.2 in Cell C2 for an example . I know how to count the number of occurrences of a certain cell within a table. However I want to be able to exclude the count of duplicate within a zone. In the table C2.2 appears 4 times. However I want to exclude duplicates within the zones and only...
    • psmi123
    • Thread
    • array countif duplicate count index & match sumproduct
    • Replies: 9
    • Forum: Excel Questions
  3. J

    How to count unique values with few criterias between two lists/ Count the number of duplicates with few criterias bwtween two lists

    For example, I have two list, each with three columns of criteria. From here I want to find the number of unique customer ID that bought orange on Wednesdays. List 1 <tbody> Customer ID (Column A) Items bought (Column B) Day (Column C) 1 Orange Wednesday 2 Apple Tuesday 5 Pear...
    • jychuah
    • Thread
    • column div/0 error duplicate count orange unique count
    • Replies: 0
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top