Excel's ascending and descending sort options are powerful tools, but they won't always sort values in a familiar and meaningful way. When this is the case, you might need a custom sort. Sorting is a ...

Seems Excel doesn't like sorting multiple decimal place lists. I tried to write a customer filter, but wild cards don't seem to work. Writing a full filter for 1, 1.1, 1.1.1, 1.1.2, etc. would be an ...

When it comes to mundane office programs, spreadsheet editors are some of the most powerful and versatile tools you're likely to come across. While Microsoft's Excel is what you likely associate with ...

I'm working with a VERY large excel spreadsheet and I'm trying to apply a bunch of formulas to some sorted data. The way the data is sorted normally, I can't easily apply a formula that will work for ...

Doug Wintemute is a staff writer for Forbes Advisor. After completing his master’s in English at York University, he began his writing career in the higher education space. Over the past decade, Doug ...