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.
2 comments:
Many thanks for sharing this very good article. s128 Very interesting ideas!
Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. Go with site instagram viewer to download free anything you like on instagram.
Post a Comment