Sort an excel table for days of the week

I would just like to know if there is any function or way to sort for the days of the week (“Monday”, “Tuesday”, “Wednesday” … etc) in an excel table.


something like in the picture

ooh and if someone knows how to define another type of view (page break preview for example) in excel I would appreciate it if you would share the way to do it.

Thank you :slight_smile:

Reading a range creates a datatable object. A datatable may be sorted (e.g. https://stackoverflow.com/questions/12472913/sorting-a-data-table). Alternatively, use Excel to sort the range in advance.

1 Like

The problem with the solution of the datatables is that the excel contains references and not real data, so it does not let me read them(send an error).
The solution through excel would be shortcuts or how?

If this doesn’t work, give the Read Range activity a shot (not the one that requires an Excel Scope). I believe this one yields values instead of formulas or refs, but I might be mistaken.

1 Like