View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Qban
 
Posts: n/a
Default 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.