Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Counting Unique Values

Hi, I have a column with a project number and project part name. I would like to return another column with only the unique project parts and the number. The filters on the page/column must rema...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi,

    I have found the solution via filters. So there was no formula necessary.

    Thanks for the help!

Icey's avatar
Icey
Community Support
4 years ago

Hi Anonymous ,

 

The table should look something like this after the formula.

Projectnumber Project part name Total
10011001 Station 1 3
20022002 Station 2 5
30033003 Station 3 6
40044004 Station 4 1

 

How about the original table before the formula? I need to compare the original table with the result table.

 

 

Best Regards,

Icey