duplicates count

  1. F

    Counting the number of different duplicates in a list

    I have a list (column, say) of numbers. They will be recalculated continuously as part of an optimization routine. I need to generate another list (column) that counts the number of different duplicates in the original list, preferably ranked. (This is what the Tally command does in...
  2. T

    CountIf without Duplicates

    I want to account for the total number of assets on hand, but there seems to be a duplicate problem I can't solve. I've got a total of 45 items under 2 customers, with 7 cells formulating for all items status/location. The current formula I'm using to count the totals is...
  3. W

    Code/formulat to count values based on different columns and not including duplicates

    Hello everyone. I could really use some help with this problem I'm having (Sorry if the image is scaled too large: check the image with the following link if you can't see to column M, or resize screen: http://i.imgur.com/rJYRCPL.png) What I would like to do is to be able to count unique...
  4. P

    Don't count duplicates (conditions)

    Hello everyone, Sorry if my english is bad. I'm searching for a formula: Count all item numbers in BF that have: An A1 in H Don't count duplicates in BF Don't count item numbers that start with N in BF (example: N 909 915 02)
  5. A

    Formula returns 0 with lots of data

    Hi - using Excel for Mac and have a large volume of data (40k records) - col A is customer name and col B is policy type. To count how many customers have (say) 3 policies I was previously told to use: To count how many customers have three policies...

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