How can I assign a different value to a number (for rankin..

rustyuser58 · External Since: Nov 06, 2009 Posts: 1

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

Daryl S · External Since: Nov 03, 2009 Posts: 4

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?

Basta1980 · External Since: Aug 19, 2009 Posts: 4

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?

Francis · External Since: May 15, 2009 Posts: 15

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?

Dave Peterson · External Since: Jul 08, 2005 Posts: 16049

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