Results 1 to 4 of 4

Help in Groupings

Threaded View

  1. #1
    Registered User
    Join Date
    03-18-2009
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    5

    Help in Groupings

    Hi guys,

    I have a table with 2 columns as per table below:

    Country Count
    -------------------
    AUSTRIA--------- 1
    BAHAMAS-------- 3
    BARBADOS-------- 2
    CANARY ISLANDS- 6
    COLOMBIA-------- 9
    GUATEMALA-------11
    LUXEMBOURG----- 15
    MACEDONIA------ 6
    PAKISTAN-------- 8
    RUSSIA----------- 13
    TAIWAN---------- 3
    KENYA----------- 5
    ANDORRA-------- 15
    BELGIUM--------- 1
    CHILE----------- 3
    CYPRUS--------- 6
    FINLAND-------- 14

    How can I count them by using these groupings 1-5,6-10,11-15? So I will have now a table like this:

    Group Count
    -------------
    1-5----- 6
    6-10---- 5
    11-15--- 5

    Please help.thanks
    Last edited by arvi; 04-28-2009 at 08:30 AM.

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