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.
Many thanks for sharing this very good article. s128 Very interesting ideas!
ReplyDeleteAny 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.
ReplyDelete