Forum Discussion
EXCEL FREQUENCY FUNCTION
I am trying to calculate the frequency of the first digits of a set of normally distributed numbers. I generated a random set of number that are normally distributed by which I then generated the fi...
I realized late last night that the LEFT function might be returning a text number due to having to converting it to a number when I pasted special. I changed the field format from General to a Number so there is definitely numbers in the array fields and it still did not make a difference.