+ Reply to Thread
Results 1 to 1 of 1

How to obtain progressive values from a larger range of values X/Y

  1. #1
    Forum Contributor
    Join Date
    06-11-2012
    Location
    Edmonton, Canada
    MS-Off Ver
    Excel 2010
    Posts
    124

    How to obtain progressive values from a larger range of values X/Y

    I have two tables, how is it possible to derive a score on the right (column2) from a cell with a value from the left (column1)

    0 -> 1

    1-2 2-3

    3-4 4-6

    5-8 6-7

    9-12 8-9

    13-16 10-11

    17-23 12-13

    24-32 14-15

    33-48 16-17

    49-65 18-19

    66-96 20-21

    97-128 22-23
    Last edited by Joah; 06-14-2012 at 10:01 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1