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 trialPhilip Schultz
11,437 PointsReturn 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
1 Answer
Steven Parker
231,186 PointsYou 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.
Philip Schultz
11,437 PointsPhilip Schultz
11,437 PointsShould I just use a filter? Is there a way to do it with a formula?