Sorting a List and determining value

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

Guest

I have worksheet with 13 columns and 9 rows. I want Excel to sort the data
and give a numeric value (1-9) for whichever place that data is in. For
instance, the highest value in a column would be given a 9, the second
highest an 8, etc... Is there a way to do this?
 

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

Create sorted list based on cell values 7
Showing the top result from a range of cells 6
Find Highest Value for Each Record 2
How to determine the higest value? 4
How to determine the values? 1
How can I sort data and have the highest value red, 2nd blue, ect 3
How to determine the number from given condition? 7
Sorting 4 rows of data and changing the text of the highest value. 2

Back
Top