So, I expect this is simpler than I think it is and I'm hoping someone can help me find a solution. I have a table in which I'm recording results from multiple trials in a test. In Column A is the position number 1-150. Each successive column I've recorded the finishing position of each participant. Each participant is represented by a numerical value. What I'm looking for is a formula that will give me the top finishing position for a specific value across all trials, and one that will give me the lowest finishing position for a specific value across all trials. This falls under the category of something I KNOW Excel can do, I just don't know how to make it do it. Thoughts?