Announcement

Collapse
No announcement yet.

Grading based on multiple criteria

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Grading based on multiple criteria



    Hello all! I'm trying to create a formula to assign a "grade" or classification based up multiple criteria. It would need to assign a rank to the top 30%, the next 20%, the next 30%, then the remaining 20%. I've attached an example of what I'm trying to do, the "grade" would go in column G.

    Appreciate any help you can give.
    Attached Files
Working...
X