Saturday, September 11, 2010

MS XL Index & Match functions

I needed to reference the column heading for each row based on the max value of a series of columns. This post on the Ozgrid Excel Help & Best Practices Forums provided the quick answer using the INDEX & MATCH functions. http://www.ozgrid.com/forum/showthread.php?t=67827&page=1

Shows how to reference the value of the row (or column) headings in a matrix at which a maximum value in each row (or column) of the matrix is located.

No comments: