You're welcome.

But please post back in this thread as you develop the concept of what you want
to do next.

Best wishes,



On Thu, 27 Oct 2005 01:00:07 GMT, "Sam via OfficeKB.com" <u4102@uwe wrote:

Hi Ron,

Thank you very much for the Formula to determine the percentage of any sample
value.

Cheers,
Sam

Ron Rosenfeld wrote:
I'm still not sure what you're getting at.

However, to determine the percent of any sample value, you can use the formula:

=COUNTIF(rng,sample_value)/COUNT(rng)

Hi Ron,

[quoted text clipped - 26 lines]

--ron

--ron

--ron