View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JumboShrimps JumboShrimps is offline
external usenet poster
 
Posts: 4
Default First, Last occurance of date in column

Have ONE column of a little more then 1,000 dates, each in a different
cell.
Column is NOT in date order, nor can it be sorted.
Need to to know the first CELL LOCATION of a date,
and then the last CELL LOCATION of a date all in ONE (same) column.
Average 100 cells between first cell location of date and last cell
location.

Thanx.