I am trying to pull a list of unique values from one sheet to another

I am trying to pull in a list of distinct values to sum. I have a sheet with a project number, date, and a value (project id, date, amount) and I have merged all of those together for a helper column. Now I want to pull that helper column's distinct values into another sheet once. The original sheet may have the values listed multiple times.

Find more posts tagged with

Accepted answers

All comments

SoS | Dan Palenchar

When you say "distinct values" which column is this based on? The value itself, the project number, etc.?

Barb R

The helper column where I have conjugated the values.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.