I have a column with several (650+) dates going back to 1975.
I'd now like a table that tells me how many entries I have per year.
Try a pivot approach. Fast n easy.
Assuming real dates running in A2 down, with col header: Date in A1.
Select say, A2, then click Data Pivot table. Click Next Next. In step 3
of the wiz., click Layout, then drag n drop "Date" into both ROW and DATA
areas. Click OK Finish. Hop over to the pivot sheet. Right-click on "Date"
Group & Show Detail Group. In the Grouping dialog, select Years OK, to
get the required results.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---