counting duplicates

  1. M

    Counting duplicates and assigning a tag

    I am looking for a formula which can assign a code based on predefined criteria <tbody> A B C D E 1 Strategy Name Area Calls Priority 2 S1 Amy Bakery 0 3 S2 Jane Bakery 1 4 S3 Jane Bakery 1 5 S1 Amy Bakery 0 6 S1 Peter Bakery 2 7 S3 Peter Bakery 2 8 S2 Jane Bakery 1 9...
  2. R

    Counting multiple occurrences of a number

    Hello Everyone, Column A contains multiple file ID numbers which can be repeated . Column B contains the operator name who will work on the these file numbers. I want to count the total number of unique file ID numbers which an operator will work on (i.e. not counting the repeated file ID...
    • rac241985
    • Thread
    • counting duplicates counting question counting unique data
    • Replies: 1
    • Forum: Excel Questions
  3. B

    counting multiple entries to equal 1 item in pivot table

    Hi Everyone, I am pretty much useless at formula writing. I need a pivot table to be able to calculate the following data (below) as number of different subjects (count all duplicates as 1 but only for the specified teacher( eg:10 subjects instead of 12 (total number) or 7 (counting ALL math as...
    • Beany27
    • Thread
    • counting duplicates counting occurences counting recurring values counting unique pivot
    • Replies: 3
    • Forum: Excel Questions
  4. C

    Sorting/Counting subject ID's and study time points

    Hi everyone! I need help. I have some data for a study I'm trying to sort according to certain conditions and have no clue how to do it. I have some 940 something subject ID's that were visited for bloodwork at two different time points, 6 months and 18 months. Some ID's were only visited at...
  5. N

    Counting duplicates

    Hello, I have a list of contact information which has a very large number of duplications. I was able to filter it down to unique values, but I've been asked to add a column which states the number of times each entry was repeated in the original list. We want this (each character is a column)...
    • nguindon
    • Thread
    • contact info counting duplicates csv database duplicates
    • Replies: 3
    • 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