Can you return the data from a different column on the same row?

Skim

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)

Thank you,

Paul Newcome

Try something like this in a sheet summary field...

=INDEX([Project Name]:[Project Name], MATCH(MAX([Deemed Valid Processing Days]:[Deemed Valid Processing Days]), [Deemed Valid Processing Days]:[Deemed Valid Processing Days], 0))

Paul Newcome

Try something like this in a sheet summary field...

=INDEX([Project Name]:[Project Name], MATCH(MAX([Deemed Valid Processing Days]:[Deemed Valid Processing Days]), [Deemed Valid Processing Days]:[Deemed Valid Processing Days], 0))

Skim

Perfect that did the trick.

Thanks Paul!

Paul Newcome

Happy to help. 👍️