Results 1 to 2 of 2

[SOLVED] Create a table based on top ranking criteria, based on multiple fields.

Threaded View

  1. 11-13-2017, 03:43 PM #1
    stevensimon10482
    stevensimon10482 is offline
    Registered User
    Join Date
    05-03-2017
    Location
    los angeles
    MS-Off Ver
    365
    Posts
    25

    [SOLVED] Create a table based on top ranking criteria, based on multiple fields.

    Hi -

    How would I take the dataset in A1:C27 and create something like the table in E5:G12?

    It's three things: (1) For each unique value in Column A, (2) I want Column B's top-two results from Column C, and (3) I want to count them. So would this be best done in a pivot table or a formula?
    Attached Files Attached Files
    Last edited by stevensimon10482; 11-14-2017 at 09:41 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy multiple fields based on criteria
    By JonSnow in forum Excel General
    Replies: 5
    Last Post: 08-09-2017, 04:12 PM
  2. Ranking Question - Ranking based criteria but having forumla value issues
    By harp1983 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-09-2016, 07:03 AM
  3. Ranking Based on Multiple Criteria
    By khannadh in forum Excel General
    Replies: 4
    Last Post: 09-02-2015, 08:20 PM
  4. [SOLVED] How to create a Calculated Field based off two Avg fields in a Pivot table?
    By rcocalm in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-22-2014, 03:18 AM
  5. [SOLVED] Finding Nth ranking value based on multiple criteria
    By scaffdog845 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-26-2013, 01:00 PM
  6. Concatenate Pivot Table fields based on criteria
    By dluhut in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2012, 12:52 PM
  7. Excel 2007 : How to create a template that automatically populates fields based on lookup table
    By tiggi in forum Excel General
    Replies: 1
    Last Post: 02-06-2012, 02:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1