formula that tells me the smallest width measured and the largest

System

This discussion was created from comments split from: Find Max and Min values in one cell.

MeganMc

I built a survey form that measured the width of doors, all the different widths are on one row, and now I am trying to get a formula that tells me the smallest width measured and the largest

HALP

Paul Newcome

@MeganMc Are you able to provide some screenshots for context?

MeganMc

Hi @Paul Newcome we found a solution :) thanks for the follow up

Andrée Starå

Hi @MeganMc

I hope you're well and safe!

Excellent! I'm glad to hear that you solved it!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!