=LARGE Formula Question

Alright Smartsheet gurus, I need a hand!

I am familiar with the LARGE function and how to use it to identify the highest numerical values in a column. However, what I am trying to accomplish is to feed that data into a dashboard that identifies those values' corresponding categories.

For example:

Location1	100
Location 2	230
Location 3	85

How would I pull the Location name with the corresponding values? Or is this a pipe dream?

Thanks in advance! Hope I was articulate enough.

Find more posts tagged with

Forms

Sheets

Formulas

functionality

Accepted answers

Paul Newcome

You would use the LARGE function to pull in the numbers then use INDEX/MATCH, INDEX/COLLECT, or JOIN/COLLECT to essentially match on those numbers and bring the corresponding location(s) over.

All comments

Paul Newcome

You would use the LARGE function to pull in the numbers then use INDEX/MATCH, INDEX/COLLECT, or JOIN/COLLECT to essentially match on those numbers and bring the corresponding location(s) over.

Scott.Brown

Perfect, thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.