Return Range of Numerical Values in Single Column based on Frequency Percentage
On Wed, 26 Oct 2005 20:17:47 GMT, "Sam via OfficeKB.com" <u4102@uwe wrote:
Hi Domenic,
Domenic wrote:
Can you provide an example?
A small sample:
Column C
58
53
57
51
53
53
68
55
54
63
51
55
59
53
51
52
56
55
67
53
52
60
57
51
60
53
52
73
52
52
54
53
51
54
53
57
66
53
51
54
57
65
52
52
52
52
52
63
54
51
Cheers
Sam
How about an example of data and inputs WITH RESULTS??
None of your numbers appear 70% of the time. 52 is the most common entry and
it only appears 20% of the time.
--ron
|