Yep! It looks like I didn't test it fully. As far as your formula...I
think for now I'll go cower in some corner. :)
Thanks Aladin!
Aladin Akyurek Wrote:
Domenic,
That formula as such won't work. Consider:
Data Code
1 x
1 x
2 x
2 y
3 y
3 y
Filter for Code = x. The result that you'll get will be: 1.5 instead of
2.
--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread:
http://www.excelforum.com/showthread...hreadid=273885