+ Reply to Thread
Results 1 to 14 of 14

Rank formula based on condition

Hybrid View

  1. #1
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,992

    Re: Rank formula based on condition

    Quote Originally Posted by shrijan View Post
    THanks guys, what if the sales column is in % (not $).
    It will work whatever you have in numerical value, I think

    Mr. Biff Can you confirm us it can work or misbehave??
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Rank formula based on condition

    Quote Originally Posted by shukla.ankur281190 View Post
    It will work whatever you have in numerical value, I think
    Yes, it should work on any numeric value.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,992

    Re: Rank formula based on condition

    Quote Originally Posted by Tony Valko View Post
    Yes, it should work on any numeric value.
    Thanks Mr. Biff

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Rank formula based on condition




    -------------

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 04-27-2015, 08:50 AM
  2. Formula to rank based on average?
    By mrbusto71 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-28-2014, 06:35 PM
  3. Replies: 2
    Last Post: 09-04-2014, 02:08 PM
  4. Rank formula based on a exclusion criteria.
    By Jabba69 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-08-2014, 08:39 AM
  5. I need a formula that will rank based on highest data
    By agorman83 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2014, 08:50 AM
  6. [SOLVED] A formula to rank the Top 10 products based on month selection
    By Aland2929 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2013, 12:54 PM
  7. Replies: 1
    Last Post: 08-15-2005, 05:05 PM

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