| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Every Occurance matching one Row and One Column | Excel Discussion (Misc queries) | |||
| Percentage of the occurance of a word in a date range | Excel Worksheet Functions | |||
| Count occurance of a month in a column of dates? | Excel Worksheet Functions | |||
| Countinge the occurance of numbers in a column | New Users to Excel | |||
| Can I divide a column at the first "space" occurance | Excel Worksheet Functions | |||
Threaded Mode
