How-To Geek on MSN

How to Use the VSTACK and HSTACK Functions in Microsoft Excel

You can use Excel's VSTACK and HSTACK functions to append data in regular cell ranges, Excel tables, or named ranges. into cell E1 stacks the three arrays in the cell ranges A2 to C6, A9 to C13, and ...
How-To Geek on MSN

How to Use the TOCOL and TOROW Functions in Microsoft Excel

The TOCOL and TOROW functions are just two ways to rearrange data in Microsoft Excel. For example, you can flip the rows and ...
Ars Technica

Powershell v1. Find the number of columns in a two dimensional array

I'm making a script that will write a two-dimensional array to an Excel spreadsheet. The script is meant to be called from within other scripts. An outer loop runs once for every row in the array. An ...
TechRepublic

Highlight the lowest and highest value in an Excel row or column

Highlight the lowest and highest value in an Excel row or column Your email has been sent Finding the lowest or highest value in an Excel row or column is simple using the MIN() and MAX() functions, ...