LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default Assigning point values?

I have a list of (12) values that can go up or down on a daily basis. The
problem I have is that I need to assign a point value to see where each value
falls compared to the other values? Very Confusing I know, here is a short
example of whay I am trying to say:
Values
160
35
115
72
Based on this 160 would be assigned a value of 4, 115 a value of 3, 72 a
value of 2 and 35 a value of 1. Is there a formula that can do this or do I
need to figure this out on paper evertime the values change? I look forward
to any help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assigning values to words cardingtr Excel Discussion (Misc queries) 4 February 18th 06 04:30 AM
Assigning values to letters Cheri Excel Worksheet Functions 3 December 20th 05 03:55 AM
Assigning ranges for values (e.g., $1,005 the range is ">$1K to 5K jennifer Excel Worksheet Functions 1 August 11th 05 02:09 PM
assigning values by intervals Pete at FMR Excel Worksheet Functions 2 August 8th 05 03:55 PM
VB Assigning Values to a Series of Strings cincode5 Excel Discussion (Misc queries) 1 August 4th 05 11:38 PM


All times are GMT +1. The time now is 04:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"