Determining top 3 items

Chris Kirsch

In creating a safety sheet for my company, I am trying to determine the top 3 subcontractors with the highest number of infractions.  Is there a formula that can determine the top 3, when the sheet has a format like the following:

Sub x - 4

Sub y - 3

Sub z - 9

Sub w - 6

Sub v - 11

Sub t - 1

Sub u - 5

Any help would be appreciated!

L_123

This is an interesting problem that I currently don't have the time to finish, but I can get you started.

=RIGHT([Primary Column]5, LEN([Primary Column]5) - 8)

Will grab the number out of the chain.

https://exceljet.net/formula/match-next-highest-value

I believe will function in smartsheet as well.