Excel 2003 function??????

  • Thread starter Novice at the Computer
  • Start date
N

Novice at the Computer

I own car yard. I in colum A i have Sales People and in colums H I J i got 3
months figures of what they sold. I want a ranking formula that works for all
colums as 1. so if colum j John is first then rank 1. then second was colum I
so 2 for fred
 
Top