Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Spreadsheet Basics Build a Spreadsheet Review Spreadsheet Basics

Philip Schultz
Philip Schultz
11,437 Points
Posted by Philip Schultz
Philip Schultz
11,437 Points

Return a cell related to another cell.

Hello, I'm drawing a blank on how to accomplish this task. The question is asking me to find the year where the most Steelhead fish passed through the dam. I know how to find the MAX number in a column, but how do I return the year at which it happened and not the number of fish? So, I basically need to return the value of one cell based on the value of another . I'm thinking I need to use the CHOOSE function, but I'm not too sure how to implement it. Any help would be great! Thanks,

Here is the doc https://docs.google.com/spreadsheets/d/1cvRXoG0bUeh6_dojdGeMHNLWoiSM1ygI6OWqGtrGsn4/copy

Philip Schultz
Philip Schultz
11,437 Points
Philip Schultz
Philip Schultz
11,437 Points

Should I just use a filter? Is there a way to do it with a formula?

1 Answer

Steven Parker
Steven Parker
231,271 Points
Steven Parker
Steven Parker
231,271 Points

You could write a formula for this as a personal challenge, but all you need for the quiz is the answer.

So another approach would be to sort based on the quantity and then just read the year from the top line. :wink: