I am working on an inventory sheet that I use several times a week. I have everything in place except for the ranking of my catagory totals (highlighted rows). I have attached an example of my files and the code I am using. I would like to rank the values in column "I" for all the catagories and place that information in column "L" where highlighted.
Last edited by MSchibs; 03-07-2010 at 11:31 PM.
Hi
Try this. It assumes that you want the lowest value as the lowest ranking number.
rylo
Please Login or Register to view this content.
rylo, this is great. I need it to be the other way, the lowest value is the highest rank. What do I need to change?
Hi
Change the line
toPlease Login or Register to view this content.
ryloPlease Login or Register to view this content.
rylo, that did it. Thank you.... One last question, If I want the numbers 1-50 in rank to be a different color, how would I do that?
Hi
Try expanding it as below. Change the xxx to be the colorindex that you want to use.
ryloPlease Login or Register to view this content.
Thanks for everything.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks