Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Starting Digits
I have a really interesting question to ask. I am running an experiment that
tests the accuracy of Benford's Law, a mathematical law that predicts how often a number starts with a certain digit. I want to know if there is a formula that can count the number of values in an array that start with some digit "n" and return that value to another cell. I'm talking about tens of thousands of numbers, so it would really, really help. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Starting Digits
Try this:
=SUMPRODUCT(--(LEFT(A1:A10000,1)="9")) Counts the number of cells in the range A1:A10000 that start with the digit 9. Does that help? *********** Regards, Ron "Qban" wrote: I have a really interesting question to ask. I am running an experiment that tests the accuracy of Benford's Law, a mathematical law that predicts how often a number starts with a certain digit. I want to know if there is a formula that can count the number of values in an array that start with some digit "n" and return that value to another cell. I'm talking about tens of thousands of numbers, so it would really, really help. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mistery digits on excel | Excel Discussion (Misc queries) | |||
excel floating digits error | Excel Discussion (Misc queries) | |||
Mod 10 & 11 | Excel Worksheet Functions | |||
Counting indvidual digits | Excel Discussion (Misc queries) | |||
Least number of digits in Y-axis labels | Charts and Charting in Excel |