Wednesday 15 June 2011

Excel filter groups some dates but not others -


This can be a dumb question with a clear answer but I can not find any solution or not . So I have a 5-tab excel sheet, each tab is with different data. I've added a filter on the tabs and with some date fields, this group according to date (you can choose year and month) when you Choose drop down but others do not have this. How can I give this group option to all dates ????

Thank you

My best estimate is that all the dates text in other tabs And if so, you can convert them to date format by copying them as 1 and multiply. (Paste Special & gt; Multi for all attributes)

No comments:

Post a Comment