Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assign number to every value in a data range???
Hi guys I'm building a sheet in where I want to store data about some web-sites we surf in the net and could be interest for my company. So I insert a serie of characteristic of the web-site in the colums (usability, navigability, etc.) and in the rows an evaluation of every characteristic from 1 to 9 . So people surf in internet and when they find an interesting website they insert the info required to fill the sheet. But then for every answer I would like to assign aother number (if they say, for example, usability=1, I want assign to this value another number, let's say 9) and see this number stored in another sheet where then I can perform calculations. How can I do that? I tried with =IF.. but I cannot perform that with more than 5 values...: Thanks for your time! The dude -- the dude ------------------------------------------------------------------------ the dude's Profile: http://www.excelforum.com/member.php...o&userid=32838 View this thread: http://www.excelforum.com/showthread...hreadid=542551 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assign number to every value in a data range???
Some suggestions from a non-expert:
1. Create a list of qualifiers, eg. from "Superb" to "Extremely Bad", say in A1:A10 2. With Data/Validation you can make a list entry referring to A1:A10; this helps consistency and people dont have to remember what a score "4" means for instance. 3. In B1:B10 you list the quantified score, eg B1=100, B2=85, B3=80, whatever 4. In yr new sheet you use VLOOKUP to look up the corresponding value in B1:B10. E.g., when you have a qualifier in C12: VLOOKUP(C12,$A$1:$B$10,2,FALSE). When you have for example in C12 "Superb" for "Speed", the VLOOKUP returns "100" in the given example (Check the Help file for the right use of VLOOKUP). You can of course hide rows/columns and protect yr sheet from undesired changes. I hope this helps! GL, Henk "the dude" wrote: Hi guys I'm building a sheet in where I want to store data about some web-sites we surf in the net and could be interest for my company. So I insert a serie of characteristic of the web-site in the colums (usability, navigability, etc.) and in the rows an evaluation of every characteristic from 1 to 9 . So people surf in internet and when they find an interesting website they insert the info required to fill the sheet. But then for every answer I would like to assign aother number (if they say, for example, usability=1, I want assign to this value another number, let's say 9) and see this number stored in another sheet where then I can perform calculations. How can I do that? I tried with =IF.. but I cannot perform that with more than 5 values...: Thanks for your time! The dude -- the dude ------------------------------------------------------------------------ the dude's Profile: http://www.excelforum.com/member.php...o&userid=32838 View this thread: http://www.excelforum.com/showthread...hreadid=542551 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Match and Sort two range of data? | New Users to Excel | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |