+ Reply to Thread
Results 1 to 2 of 2

Display label when using COUNTIF

  1. #1
    Registered User
    Join Date
    07-31-2014
    Location
    calgary,canada
    MS-Off Ver
    2013
    Posts
    25

    Display label when using COUNTIF

    I'm using COUNTIFS to display how many Toyotas there are of each color. e.g. for black toyotas:

    = COUNTIFS(A:A, "Toyota",B:B, "Black")

    I need a formula that would show the label of that value e.g. "black Toyota"

    I tried

    = INDEX((A:A,B:B), MODE(MATCH((A:A,B:B),(A:A,B:B),0)))

    but it didn't work.

    Capture.PNG

  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: Display label when using COUNTIF

    Many forum members, myself included, can not see *.png images.

    It would be better if you posted a SMALL sample file that shows us what result you expect.

    20 rows worth of data is plenty. Remember, it's a sample file so the emphasis is on SMALL.
    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. [SOLVED] Display data label: Number vs. %
    By Aland2929 in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 07-29-2013, 11:38 AM
  2. Display an excel box in a vba label
    By kieranbop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2011, 03:57 AM
  3. Display label caption
    By Nancy123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-04-2010, 07:49 AM
  4. How do you display data in a label on a userform?
    By kryt0n in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 08-13-2010, 06:48 AM
  5. Display category name and Y value in data label
    By jeffreybrown in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 12-03-2009, 06:44 PM
  6. Display Cell Value on UserForm Label
    By Burke in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-20-2008, 06:59 PM
  7. label display
    By walid66 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2008, 06:10 PM
  8. X axis label problems...won't display
    By niccig in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-18-2006, 04:40 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