Snippets

Willy Pillow Excel Statement To Calculate Max

Created by Willy Pillow
=MATCH(MAX(OFFSET(INDIRECT(ADDRESS((ROW()-99),COLUMN())),0,0,99,1)), (OFFSET(INDIRECT(ADDRESS((ROW()-100), COLUMN())),0,0,100,1)), 0)

Comments (1)

  1. kurki epst

    I recently learned about how and where data packets work, and it's all thanks to this site. This site has a lot of quality and proven technical information that I find very interesting and informative to read. You should try this site too, you won't regret it! Goodbye, and I wish you a good and productive day.

HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.