Please note: This item is from our archives and was published in 2018. It is provided for historical reference. The content may be out of date and links may no longer function. Earlier this fall, ...

Q. Is it possible to sort a column in Excel using formulas rather than the Data tab’s Sort tool, so the sort process is performed automatically as I update my data? A. Excel has announced a new ...

Recently, I have been doing quite a bit of work involving the use of functions inside Excel spreadsheets. Although functions are probably most often used for computational purposes, functions can also ...