Subtotal by Year, Large Spreadsheet?
 

Hi Al

You can use this Add-in to filter on years without using a helper column with
=year(a1)
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Al Franz" wrote in message ...
Have a long spreadsheet list of rows with Date (mm/dd/yyyy) in column A. Would like to get subtotals by year. Using the FILTER
does not work since I can not select a YEAR. Do I need to break column A into 2 columns, one for mm/dd, the other for yyyy? Or
is there an easier way?