Results 1 to 2 of 2

Data Buckets (in a range)

Threaded View

  1. #1
    Registered User
    Join Date
    08-13-2006
    Posts
    1

    Data Buckets (in a range)

    I currently have data orgnised as such:

    CUSTOMER YEARS AMOUNT(USD)
    Customer A 1.2 100
    Customer B 2.5 200
    Customer C 0.66 300
    Customer D 6.2 100
    Customer E 3.4 150
    Customer F 1.7 50
    Customer G 5.0 200
    Customer H 4.2 25

    I have a big spreadsheet of around 6000 rows and would like to rearrange the data into a range bucket by years (using pivot tables), i.e.

    YEAR BUCKET AMOUNT(USD)
    0-3 650
    3.1-5 375
    5.1-10 100


    Many thanks in advance for your help

    Attached is the excel version of the example above
    Attached Files Attached Files
    Last edited by salireza; 08-13-2006 at 11:43 PM.

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