Nested IF statements used to be my go-to whenever I needed to juggle multiple conditions in Excel. However, just because they get the job done doesn’t mean they’re the best tool for the job. Wrestling ...
The SORT and SORTBY functions let you extract certain columns and rows from a dataset and sort them in a certain order, all while preserving the source data. Even though they work in similar ways, ...
If you are interested in Excel’s text functions, you can also read the August 2023 Tech Q&A article “Join Text in Excel”, which explains the function TEXTJOIN, and the previous item in this month’s ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback