Good day to All,
I have a table from Column A to F and I want them to be sorted out according to their dates. I am looking for a formulas or VBA which is sorting the whole Columns from A to F based on the dates from oldest to latest. The date format is dd-mmm-yy and it is in the Column F. By the way, I am using MS Excel 2010.
I tried to use the "Custom Sort" but it gives me the wrong arrangement. Any helps much appreciated.
Thank you in advance.
I have a table from Column A to F and I want them to be sorted out according to their dates. I am looking for a formulas or VBA which is sorting the whole Columns from A to F based on the dates from oldest to latest. The date format is dd-mmm-yy and it is in the Column F. By the way, I am using MS Excel 2010.
I tried to use the "Custom Sort" but it gives me the wrong arrangement. Any helps much appreciated.
Thank you in advance.