How can I assign a different value to a number (for ranking)?

  • Thread starter Thread starter rustyuser58
  • Start date Start date
R

rustyuser58

I want to assign a different value to a number in order to weigh a ranking,
ie: 1=10. Can I do that?
 
Maybe you could insert a new worksheet and create a table that you can use in an
=vlookup() formula.

=vlookup(a1,sheet2!a:b,2,false)
 
Rustyuser58 -

You can use a separate tab in your workbook to set up the conversions. For
example:

1 10
2 15
3 50

Then in your original spreadsheet, use a VLOOKUP on your original number to
display the ranking from the separate tab. Look up VLOOKUP in Excel Help or
through the fx button to show you how.
 
Hi Rusty,

Try something with an if statement. Depends on how many weighing you do.

Regards,

Basta
 
I believe that this can be done
Would you provide how your data structure layout is like
and from where do you get the criteria

Pls provide a sample showing an example
--
Hope this help

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis
 
Back
Top