Results 1 to 3 of 3

analyze a column, get the adjacent integer and sum it up as a total

Threaded View

  1. #1
    Registered User
    Join Date
    05-11-2011
    Location
    Malta
    MS-Off Ver
    Excel 2007/2010
    Posts
    7

    analyze a column, get the adjacent integer and sum it up as a total

    What I would like to do is the following:

    if for e.g. i have the following statistics:

    46 23
    12 26
    102 31
    1 27
    33 25
    34 21
    55 33
    20 23
    29 27
    34 28

    and I stated before for example if I choose the number 33, then I know that the numbers greater or equal to 33 (in the 1st column) are the 46, 102, 33, 34, 55 and 34 and it appears 6 times.

    Is it possible to choose automatically their respective adjacent number (2nd column) such as 23 (for 46), 31 (for 102), 25 (for 33), 21 (for 34) and add them up as a total?

    Thanks!
    Last edited by NBVC; 05-13-2011 at 07:55 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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