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

Barb R

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.

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.