+ Reply to Thread
Results 1 to 4 of 4

How to Rank a Supplier Rate Table

  1. #1
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    792

    How to Rank a Supplier Rate Table

    Evening all,

    I've read numerous threads on this but I'm struggling to understand it sufficiently enough to apply it to my workbook. Basically I've got a table with a schedule of rates for different suppliers and I just need to rank them in ascending order. Simples right?!?!

    Example attached.

    Thanks in advance,

    Snook
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,891

    Re: How to Rank a Supplier Rate Table

    Can't you simply sort the table on column C? If you want to use a formula instead, try these:

    F4 =SMALL($C$4:$C$29,ROWS(A$1:A1))
    E4 =INDEX(B$4:B$29,SMALL(IF(C$4:C$29=F4,ROW(C$4:C$29)-(ROW(C$4)-1)),COUNTIF(F$4:F4,F4))) Ctrl Shift Enter

  3. #3
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    792

    Re: How to Rank a Supplier Rate Table

    Works a treat, thanks!

    Snook

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,891

    Re: How to Rank a Supplier Rate Table

    You're welcome. Happy to help.

    Thanks for the rep!

+ 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. [SOLVED] Lookup Fee Based on Supplier and Rate Charged
    By The_Snook in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-20-2016, 06:44 PM
  2. Formula to Identify Lowest Supplier (not just rate)?
    By Soozm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2014, 07:36 AM
  3. I have supplier name in excel.. I need a VBA to the Supplier Web URL
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2013, 01:25 AM
  4. Need to make a rate table... Please help
    By cmclark in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2013, 11:08 PM
  5. Replies: 3
    Last Post: 05-08-2013, 07:25 AM
  6. [SOLVED] How to lookup tax rate from a reference table?
    By icarrington in forum Excel General
    Replies: 4
    Last Post: 08-23-2012, 04:43 AM
  7. Populate Rate Table
    By Kumara_faith in forum Excel General
    Replies: 2
    Last Post: 08-18-2009, 04:41 AM

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