How to use rank function

Hi,

i have a table as below , I need to rank the suppliers region wise .So based on average weight, i rank a supplier only specific to that region . So every region would have its separate ranking based on weights.