Results 1 to 4 of 4

change value in roll as the column sum changes using data from a table.

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2013
    Location
    Riverton Wyoming
    MS-Off Ver
    Microsoft Home Office 2024
    Posts
    50

    change value in roll as the column sum changes using data from a table.

    I have the following data:

    a b b c d e f
    1-Jan-15 22.48 15.89 17.45 21.11 16.71
    1-Feb-15 15.05 18.49 6.21 5.47 15.74
    1-Mar-15 5.67 2.44 5.27 8.01 16.15 16.71
    1-Apr-15
    1-May-15

    43.2 28.33 23.76 31.67 42.73 49.16

    Rank 5 7 7 6 5 5


    Score Table
    low high Score

    0 9.99 NA
    10 19.99 8
    20 29.99 7
    30 39.99 6
    40 49.99 5
    50 59.99 4
    60 69.99 3
    70 70.99 2
    80 89.99 1

    as the sums for the columns increase, I need the rank roll to change according to the new sum using the Score table. My actual spread sheet has 31 columns. I really do not want to use a bunch of embedded if statements or a bunch of embedded "and" statements.updating score rank.xlsx
    Last edited by rafcaf; 05-01-2015 at 06:07 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change Pivot Table Data Source to range A7: last record in F column
    By johnstevens in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-09-2014, 08:35 AM
  2. Replies: 3
    Last Post: 08-27-2013, 11:10 AM
  3. Replies: 1
    Last Post: 04-20-2013, 03:55 AM
  4. Pivot Table to roll up data and display in pivot chart
    By Dawson64 in forum Excel General
    Replies: 3
    Last Post: 09-26-2011, 05:06 PM
  5. Replies: 1
    Last Post: 02-03-2005, 12:59 PM

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