Thread: RANKINGS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Novice at the Computer Novice at the Computer is offline
external usenet poster
 
Posts: 1
Default RANKINGS

I have numbers in colums G, I and K that i want in a first place to 600
place. Ranking from high to low

EG

Colum G3 answer is 150
BUT
Colum K 15 answer is 255

Therefore K15 should now show number 1 and G3 in number 2 AND SO ON

Each Colum goes from Row 3 to Row 198