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 wrote:

I want to assign a different value to a number in order to weigh a ranking,
ie: 1=10. Can I do that?

--

Dave Peterson

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.

--
Daryl S


"rustyuser58" wrote:

I want to assign a different value to a number in order to weigh a ranking,
ie: 1=10. Can I do that?

Hi Rusty,

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

Regards,

Basta

"rustyuser58" wrote:

I want to assign a different value to a number in order to weigh a ranking,
ie: 1=10. Can I do that?

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





"rustyuser58" wrote:

I want to assign a different value to a number in order to weigh a ranking,
ie: 1=10. Can I do that?