View Single Post
  #4   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default 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