View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Alan is offline
external usenet poster
 
Posts: 152
Default Compare values in different columns

Is there a way to compare numbers in different columns and return a different
value based on the findings.
Given Data:
A1 B1 C1
100 50 250

Desired Results:
A2 B2 C2
2 1 3

Basically I want to assign the lowest number of the Given Data the value of
"1" the next higest number of the given data the value of "2"...

Thank you,
Alan