Excel's OFFSET function lets you create a reference that isquite literally offset from a starting point. It allows references to adjust dynamically to changes in your spreadsheet's data and structure.

Got a whole bunch of data in a row or column that needs to be sorted alphabetically? You can do it with just a few clicks in Excel.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.

Learn how to easily set up your own search field in Excel to find and filter content within a table.

Data mining your general ledger with Excel Learn how to use Microsoft’s ubiquitous spreadsheet application to unlock the wealth of information stored in your company’s financials.

T_Targets is the array, T_Targets [Points] is the name of the column containing the data that the array will be sorted by, and -1 tells Excel to sort T_Targets [Points] in descending order.