ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Trying to sort list by month (https://www.excelbanter.com/excel-discussion-misc-queries/17431-trying-sort-list-month.html)

Chip

Trying to sort list by month
 
Dealing with list and trying to take only data from one month example Jan or
1/2/2005. Have multiple data for each month.

Ron de Bruin

Hi Chip

You can add a helper column with a formula like this
=Month(A1)

But maybe you like my filter Add-in that have a option to do this without
adding a helper column
http://www.rondebruin.nl/easyfilter.htm



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



"Chip" wrote in message ...
Dealing with list and trying to take only data from one month example Jan or
1/2/2005. Have multiple data for each month.





All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com