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...
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...
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...
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)
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 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.