Compare values in different columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use the rank formula something like this...

=RANK(A1, $A$1:$C$1)

It returns the rank of A1 in the range A1:C1...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing two columns in vba 2
Compare and replace if equal 6
VBA to create new data help please 2
Can a formula do this? 1
Matching Data between 2 Tabs on Same Workbook - then calculating 2
Comparing values or text in 2 different workbooks 2
Macro that analyses data from 3 columns and puts result in 4th 2
Insert columns and values programmatically with IF statement 9

Back
Top