change-sort-orientation-excel-columns
You can sort data across columns instead of rows by changing sort options. If you ever had to sort across columns now you know a simple way to do this 🙂
Follow these steps for changing sort orientation:
- Select the table you want to sort (just the data, not the headers as when you change sort orientation, you cannot set header rows)
- Go to Data > Sort
- Click on Options
- Set “Sort Orientation” to “left to right” instead of “top to bottom” as shown below:
- Click OK
Also see: How to count words in an excel cell, Fill only weekdays when auto-filling dates, Find unique items in a list
8 Responses to “What is LAMBDA? 4 Practical examples to REALLY understand it”
Thanks so much for this, it's utterly brilliant!
Silly question - I assume LAMDA will work with dynamic arrays?
Very much so. Many of the new functions like MAP only make sense in the context of dynamic arrays and Lambda functions.
As usual, very informative material. Easy to understand and apply!
Thanks for making everyone awesome!
Easy to understand Lambda function through this tutorial. Thanks Chandoo.
I have Officce 365 (updated), but I can't see LAMBDA function. 🙁
I dont see "Office Insider" option in my excel 365.
Another option for First Monday...
=LAMBDA(anydate,WORKDAY.INTL(EOMONTH(anydate,-1),1,"0111111"))
Loving the binary options in WORKDAY.INTL David...