Hi Ron

Thanks for reply.

1. The Average of your values is not 6, but rather 6.090909091. How, exactly,
do you want to process non-integer averages?

Rounded to nearest integer.

2. How do you decide which Label to return if you have duplicate Values? In
other words, if the processed average is 9, how do we tell whether to return
84, or 85?

The first matched Label.

Cheers,
Sam


Ron Rosenfeld wrote:
Hi All,

[quoted text clipped - 27 lines]
Thanks
Sam

Need more information.

1. The Average of your values is not 6, but rather 6.090909091. How, exactly,
do you want to process non-integer averages?

2. How do you decide which Label to return if you have duplicate Values? In
other words, if the processed average is 9, how do we tell whether to return
84, or 85?

--ron


--
Message posted via http://www.officekb.com