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

Jesse Stanley

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?

johngraham78

For two given rows that have the same job number, is there any distinguishing factor between them. That is, are the rows identical or duplicate?