Can you return the data from a different column on the same row?
I have a portfolio sheet with multiple projects. The goal is to calculate which of these project studies are both the longest timeline and shortest timeline based on ""Deemed Valid Processing Days". I created a separate column for the formulas, I would like to pull results into a dashboard.
Can I use a nested formula inside of MAX or MIN and have it return the "project name" column instead of the actual value of "Deemed Valid Processing Days"? If so how do which formula and how do I return the value of "project name" column instead of the value of the MAX or MIN formula?
=MAX([Deemed Valid Processing Days]1:[Deemed Valid Processing Days]50)
Help Article Resources
Check out the Formula Handbook template!