+ Reply to Thread
Results 1 to 2 of 2

Show lowest value from 3 columns in pivot table

  1. #1
    Registered User
    Join Date
    04-14-2015
    Location
    Utah
    MS-Off Ver
    2013
    Posts
    1

    Show lowest value from 3 columns in pivot table

    I'm at my wit's end here. I have a table with a number of columns. Of 3 specific columns, I need to find the amount of times each column shows the lowest number of the 3 columns, for each row. . For example:

    Column 1 Column 2 Column 3
    25 18 12
    11 20 22
    13 28 14
    19 15 17
    17 21 23
    24 9 11


    I have to show how many times each column shows the lowest number in each row. For instance, Column 1 shows the lowest number for 3 rows. Column 2 shows the lowest number for 2 rows. And, column 3 shows the lowest number for 1 row. I hope it makes sense.

    I just need to show each one on a pivot table. So, I'm not sure if this would be a function I enter from the original data, or if it's certain setting once the pivot table is set up. But, any help would be great!!

  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: Show lowest value from 3 columns in pivot table

    Not sure how you'd do it within a PT but here's a formula method.

    Data Range
    A
    B
    C
    2
    25
    18
    12
    3
    11
    20
    22
    4
    13
    28
    14
    5
    19
    15
    17
    6
    17
    21
    23
    7
    24
    9
    11
    8
    ------
    ------
    ------
    9
    10
    3
    2
    1


    This formula entered in A10 and copied across:

    =SUMPRODUCT(--(A2:A7=SUBTOTAL(5,OFFSET($A2:$C2,ROW($A2:$C7)-ROW($A2),0))))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Show all columns in pivot table
    By bongielondy in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-24-2013, 07:10 AM
  2. [SOLVED] Multiple Columns in Pivot Table (but don't show in Pivot Chart)
    By Gideon1973 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-23-2012, 10:57 AM
  3. Replies: 7
    Last Post: 08-04-2011, 09:32 AM
  4. Replies: 2
    Last Post: 04-14-2010, 05:26 PM
  5. Replies: 7
    Last Post: 01-30-2005, 02:06 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