+ Reply to Thread
Results 1 to 3 of 3

Index, match, smalls to return nth occurrence of value in row and display column header

  1. #1
    Registered User
    Join Date
    03-05-2019
    Location
    [email protected]
    MS-Off Ver
    Office 2013
    Posts
    2

    Index, match, smalls to return nth occurrence of value in row and display column header

    Hi folks,

    Need your help. I'm trying to find an equation to insert into cells E2:G5 that will look for the number of occurrences of the number “1” in a row, and then output the column header. I’ve been googling, and it seems this would require an equation using a combination of index, match, and smalls – and after two days of looking into this, I can’t figure it out.

    Would really appreciate your input and help on what equation I could use. Attaching an image of the table and pasting below as well.

    Thank you!!!

    Vince

    A B C D E F G
    1 Red Green Blue 1 2 3
    2 Bob 1 1 Red Green
    3 Mike 1 1 Green Blue
    4 Joe 1 1 1 Red Green Blue
    Attached Images Attached Images

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Index, match, smalls to return nth occurrence of value in row and display column heade

    Into E2:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    accept with Ctrl+Shift+Enter and drag it left/down as needed.

    p.s. adapted from one of forum threads, I don't remember details and author.
    Last edited by KOKOSEK; 03-05-2019 at 12:53 PM.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    03-05-2019
    Location
    [email protected]
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: Index, match, smalls to return nth occurrence of value in row and display column heade

    Thank you, Kokosek!!

+ 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. Index/Match across multiple sheets, return column header
    By TheYoungDrea in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-09-2017, 07:49 AM
  2. [SOLVED] Find Value in Table and Return Column Header for Each Occurrence
    By ers42103 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-03-2016, 09:27 AM
  3. Find Value in Table and Return Column Header for Each Occurrence
    By ers42103 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-02-2016, 04:59 PM
  4. Replies: 3
    Last Post: 01-18-2016, 10:18 AM
  5. [SOLVED] Index Match row value and nth occurrence of header
    By dm@stams in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-22-2013, 05:43 PM
  6. Return Column Header from Index/Match function
    By del24ie in forum Excel General
    Replies: 2
    Last Post: 01-12-2012, 11:57 AM
  7. Index/Match Function to Return column header
    By djmarsh51 in forum Excel General
    Replies: 2
    Last Post: 05-07-2010, 02:10 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