hello,
i have a range V5:IQ5, it contains values from 0+.

most of the values are the same. the range may contain 1 up to 11 different
valus.

I need to

1) make a formula for table of values in range (J5:T5) which will collect
each different values within the range (V5:IQ5).
2) then another formula to lookup from the range $V$2:$IQ$2, for the
corresponding series number where the data falls in the column. This formula
to be filled along range (J4:T4).

thanks and regards,
driller
--
*****
birds of the same feather flock together..