The percentile and Quartile functions exist, these can easily be
manipulated to get the tertile

Eg
if(a1<quantile(range,1),1,if(a1<quantile(range,2), 2,if(a1<quantile(range,3),3,4)))

If tertiles are what i think them to be!

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=557732