| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare values in different columns
Use the rank formula something like this...
=RANK(A1, $A$1:$C$1) It returns the rank of A1 in the range A1:C1... -- HTH... Jim Thomlinson "Alan" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare values in different columns
Thank you!!!!
"Jim Thomlinson" wrote: Use the rank formula something like this... =RANK(A1, $A$1:$C$1) It returns the rank of A1 in the range A1:C1... -- HTH... Jim Thomlinson "Alan" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare values of two columns | Excel Worksheet Functions | |||
| Compare values in different columns | Excel Discussion (Misc queries) | |||
| I want to compare the values in two columns | Excel Discussion (Misc queries) | |||
| Compare values in columns | New Users to Excel | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Hybrid Mode
