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.

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.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...