+ Reply to Thread
Results 1 to 4 of 4

Filter highest values of columns

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    152

    Filter highest values of columns

    Hi

    I have a Pivot table that shows data from a range of years of a competition.

    Is it possible to filter the table so that I can just show the highest value (and therefore the yearly champions) for each column?
    The rows are the competitors and the columns are the competition years.
    Champion each year is the person with highest point score.

    Thanks for your thoughts on this.
    Neil

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Filter highest values of columns

    it sounds like Top 10 filter

  3. #3
    Forum Contributor
    Join Date
    06-16-2010
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    152

    Re: Filter highest values of columns

    No Top 10 doesn't do it. I have managed to do with the use of a helper column where '1' is added for a Champion, then filter the Pivot using the '1'

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Filter highest values of columns

    I will not guess

    have a nice day

+ 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: 3
    Last Post: 06-09-2016, 12:51 PM
  2. Replies: 4
    Last Post: 12-18-2014, 12:55 PM
  3. Replies: 6
    Last Post: 10-16-2014, 08:42 AM
  4. Formula To Add Highest Two Values In Columns
    By alcatraz99 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-20-2013, 01:41 PM
  5. Getting the highest values from excel columns
    By chembee in forum Excel General
    Replies: 4
    Last Post: 07-30-2012, 01:03 PM
  6. [SOLVED] Removing Two Highest Values, Columns not in order
    By dmeyer1982 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-20-2012, 01:01 PM
  7. Summing Highest Values based on two columns
    By seashell in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-09-2012, 07:53 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