Gary and Ragdyer,

sorry...i forgot the last scenario
(d) out of order ...(e.g. 2,2,2,2,1,1,1,3,3,3,.....4)
----
4. if the values in out of order scenario (d)....the result will show "out
of order"....

this may complete the query..

thanks and regards,
driller

--
*****
birds of the same feather flock together..