+ Reply to Thread
Results 1 to 2 of 2

Decile Reporting function or formula

  1. #1
    Registered User
    Join Date
    09-15-2006
    Posts
    1

    Decile Reporting function or formula

    Hello, Does anyone use or know of any formulas, functions, shortcuts or any other easy way to formulate a decile report or column.

    For example, I have 600 store numbers that have a number asigned to them in a second column, that I want to decile out. Right know, I sort from high to low on the value, divide by 600 and put a number in each line. after line 61 for example, I put the second decile number, and so forth.

    As you can imagine, this is vary time consumiong, especially when they are multiple colmns for that store that need to be deciled out.

    Thanks for your help.

  2. #2
    Registered User
    Join Date
    09-18-2006
    Posts
    67

    ROUNDUP Function

    Use the ROUNDUP function
    A B C
    Store 1 1 =ROUNDUP(B1/60,0)
    Store 2 2 =ROUNDUP(B2/60,0)
    Store 3 3 =ROUNDUP(B3/60,0)
    Store 4 4 =ROUNDUP(B4/60,0)
    Store 5 5 =ROUNDUP(B5/60,0)

    Clay Ver Valen
    Excel Help
    Last edited by clayv; 09-18-2006 at 08:10 PM.

+ Reply to 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