Question: How to create unique distinct year and months from a long date listing (column A)?
You can find the question in this post: Extract dates using a drop down list in excel
Array formula in C2:
copied down as far as needed.
Download excel tutorial file
unique distinct year and month.xls
(Excel2007 Workbook *.xlsx)
Functions in this article:
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range
Counts the number of cells within a range that meet the given condition
Returns the relative position of an item in an array that matches a specified value
Converts a value to text in a specific number format