I need to rank job numbers by average cost while filtering out repeated job numbers.

I have a sheet that we log all our problem reports onto and it has repeated job numbers but individual problem report numbers for each job. I can get a ranking of the cost of the problem reports but when I put it to a report, it will have repeated job number. How do I eliminate the repeated job numbers?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!