Q
Qban
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.
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.