Yodelayheewho
Member
See attached example.
The DATA worksheet holds order data and new orders are added here
The REPORT worksheet index/matches from the DATA worksheet
REPORT worksheet: DATE1 column filter sorts Newest to Oldest.
REPORT worksheet: DATE2 column sorts A-Z.
DATA worksheet: Both columns are in date format and the hierarchy shows dates. If you look at ImageA, I show the filter menu for DATE2 and all looks fine.
REPORT worksheet: Both columns are in date format and both columns are utilizing the same Index/Match formula. However, if you look at ImageB, the DATE2 column shows sorting as A-Z
DATE2 column I tried: Data > Text to Columns > Next > Next > Date > Finish - no luck
I'm stumped.
Thank you in advance for your help.
The DATA worksheet holds order data and new orders are added here
The REPORT worksheet index/matches from the DATA worksheet
REPORT worksheet: DATE1 column filter sorts Newest to Oldest.
REPORT worksheet: DATE2 column sorts A-Z.
DATA worksheet: Both columns are in date format and the hierarchy shows dates. If you look at ImageA, I show the filter menu for DATE2 and all looks fine.
REPORT worksheet: Both columns are in date format and both columns are utilizing the same Index/Match formula. However, if you look at ImageB, the DATE2 column shows sorting as A-Z
DATE2 column I tried: Data > Text to Columns > Next > Next > Date > Finish - no luck
I'm stumped.
Thank you in advance for your help.