LOOKUP didn't pan out either, as it requires a lookup value from the array itsself, existing in the top row.<BR><BR>And no cheating! No multiple nested IF's to check every column.

To get started, open the Excel Sheet in which you would like to split a single column into multiple columns. Then, go to the ‘ Data ’ tab and select the ‘ Text to Columns ’ section.

Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.

How to Sort Multiple Rows and Columns in Excel. With Microsoft Excel's powerful sorting capabilities, you can enter unsorted data and let the software sort your data numerically, alphabetically or ...

How to Make a Two Column Spread Sheet on Microsoft Excel. Unless someone's calculator needs an upgrade, one plus one usually adds up to two. With Microsoft Excel, you can put that math to work ...

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

It's easy to alphabetize data in a Microsoft Excel spreadsheet by row or column using the "Sort" feature. You can also alphabetize in Excel using shortcuts found in the "Data" or "Home" tabs.