+ Reply to Thread
Results 1 to 3 of 3

Need a formula that would make life easier

  1. #1
    frustrated
    Guest

    Need a formula that would make life easier

    I have a basic spreadsheet for my work that keeps track of sales for a promo
    that we have going on. I woulds like a formula that will tell me who is rank
    1, 2, 3, 4,....so on. I have it so the final number in each category is a
    percent and would like to have a ranking that automatically adjust when the
    percentiles changes.
    thank you.

  2. #2
    Don Guillett
    Guest

    Re: Need a formula that would make life easier

    Have a look in HELP index for RANK

    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "frustrated" <frustrated@discussions.microsoft.com> wrote in message
    news:43079319-80EC-4DEB-9875-FC720C7A4E69@microsoft.com...
    > I have a basic spreadsheet for my work that keeps track of sales for a

    promo
    > that we have going on. I woulds like a formula that will tell me who is

    rank
    > 1, 2, 3, 4,....so on. I have it so the final number in each category is a
    > percent and would like to have a ranking that automatically adjust when

    the
    > percentiles changes.
    > thank you.




  3. #3
    Ragdyer
    Guest

    Re: Need a formula that would make life easier

    Multiposting is frowned upon in these groups.
    See your other post in the functions group.
    --
    Regards,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------
    "frustrated" <frustrated@discussions.microsoft.com> wrote in message
    news:43079319-80EC-4DEB-9875-FC720C7A4E69@microsoft.com...
    > I have a basic spreadsheet for my work that keeps track of sales for a

    promo
    > that we have going on. I woulds like a formula that will tell me who is

    rank
    > 1, 2, 3, 4,....so on. I have it so the final number in each category is a
    > percent and would like to have a ranking that automatically adjust when

    the
    > percentiles changes.
    > thank you.



+ 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