Sorting Data Within the Same Cell

  • Thread starter Thread starter NAV
  • Start date Start date
N

NAV

Is there a way to sort data that's within data being
sorted?

For example, I'm using the ddd mm/dd/yyyy format to format
dates within cells. I'd like to sort the data based on
the ddd portion of the date format (i.e., all Monday's
together, all Tuesday's together, etc.).

There are 5,000+ rows in this worksheet, so it's not as
simple as manually inputting the day information next to
the corresponding cells.

Any help would be appreciated.

Thank you.
NAV
 
Hi
use a helper column with a formula like
=WEEKDAY(A1,2)
copy this formula for all rows and sort with this row
 
Back
Top