Year1=small(a1:a700,1)
Year2=if(small(a1:a700,2)=small(a1:a700,1),"-",small(a1:a700,2))
Year3=if(small(a1:a700,3)=small(a1:a700,2),"-",small(a1:a700,3))
....
....
YearN=if(small(a1:a700,N)=small(a1:a700,N-1),"-",small(a1:a700,N)).


johnny wrote:
Hello,
I have a column that conntains years. The column is
sorted and probably will not have more than four unique
values. The range is about 700 cells. I would like to
define
Year1 as the earliest year
Year2 as the next..... and so on

If there is only one year, I would like Year2 = "-".

Any help getting me started would be great.
Thanks in advance.