Results 1 to 3 of 3

Returning the most recent values

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2009
    Location
    Surrey, UK
    MS-Off Ver
    Excel 2007
    Posts
    9

    Returning the most recent values

    Good day to you all,

    What would be the simplest way to display the following?

    Say I have an assorted list of scores in one column (column A – person name, column B – score) and I would like to return the sum of the last two (or three, four, five etc) scores for each person (bottom of the list is the most recent):

    Andrew 50
    Carol 20
    Ellen 10
    Ben 10
    Derek 45
    Fiona 52
    Ben 70
    Derek 51
    Fiona 61
    Ben 21
    Derek 81
    Fiona 20
    Andrew 90
    Carol 43
    Ellen 35
    Ben 20

    eg. In Columns C & D would display:

    Andrew 140
    Ben 41
    Carol 63

    and so on...



    Thank you

    Ks
    Last edited by Kleinstein; 08-15-2011 at 08:38 AM. Reason: closing 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