I wrote an excel formulas e-book that makes learning 75 most frequently used excel formulas as simple as eating pie. If you are wondering the book is worth your investment, read these wonderful reviews the book has received from fellow excel bloggers in the community.
Jimmy on Code for Outlook and Excel:
I really like the way the e-book sticks to only the most common formulas, since those are the ones I use most often and therefore am more likely to need help with. It’s also great if you don’t know many formulas, to use as a tutorial to help you understand each function. …
Overall a very good value and should prove useful when you are stuck trying to get a simple formula to work (which is more often than you might think).
Read the rest of his review here.
Tony on Support Analytics:
This workbook contains 75 of the most frequently used formulas that are explained in plain wording. If you are new to Excel, want to brush up on some rusty formulas or want to learn some new ways to look at data, buy this ebook today. For just $10, you can be using formulas that will save you hours worth of manual work in Excel.
Read the rest of his review here.
Go ahead and read the reviews and follow the purchase links from there if like what you hear.
11 Responses to “Who is the most consistent seller? [BYOD]”
The Date column in the sample file is Text not Dates
[…] http://chandoo.org/wp/2015/02/18/calculating-consistency-in-excel/?utm_source=feedburner&utm_med… […]
Great Chandoo. Keep it up, Looking forward more from BYOD..
Thanks
With Excel 2013 the pivot table could be connected to the data model which provides a distinct count.
This will do for invoice count
=COUNTIF(F:F,H12)
Instead of
=COUNTIFS(sales[SELLER],$H12)
Excellent document. How did you make the last graphic? Witch app. Thanks for answer.
Can someone tell me what =countif(sales[date],sales[date]) is counting? The value is 19. Its found in the =SUMPRODUCT(IF(sales[SELLER]=H12,1/COUNTIFS(sales[SELLER],H12,sales[date],sales[date]),0))
Hi Chris,
=countif(sales [date],sales[date]) function is counting the unique dates in the table.
Vândalo
Excellent document!
Can you explain more about the calculation on Weighted consistency? More specific the small number is 0,00001 ?
How come the number should be smaller if there is more sellers?
Hi,
Not understood this formula: {=SUMPRODUCT(IF(sales[SELLER]=H12,1/COUNTIFS(sales[SELLER],H12,sales[date],sales[date]),0))}
Please explain.
Thanks.