Thread: unique values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
johnny johnny is offline
external usenet poster
 
Posts: 6
Default unique values

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.