+ Reply to Thread
Results 1 to 2 of 2

Display Column Header if any value other than 0 exists in a multi-column array.

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    Philadelphia
    MS-Off Ver
    365
    Posts
    6

    Question Display Column Header if any value other than 0 exists in a multi-column array.

    Hi

    I would like to display the column header of the row in which a value other than 0 exists in a cell for each instance that value exists in an array spanning 3 columns. So the result cell could be any of the three column headers.

    I started the formula in P2 of the GL Detail-2012 tab. (FILE TOO BIG)

    Excerpt:

    Resin Sand Eliminated Segment
    - (12,896.65) -
    - (6,570.85) -
    - (11,503.80) -
    - (13,188.50) -

    If there is any value other than 0 in Resin, Sand or Eliminated columns, return that column's header under Segment.

    Here is what I started: =INDEX($M$1:$O$1,SUMPRODUCT(COUNTIF($M$2:$O$67756,)))

    Thank you very much.
    John

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Display Column Header if any value other than 0 exists in a multi-column array.

    Quote Originally Posted by Swirsjo01 View Post

    I started the formula in P2 of the GL Detail-2012 tab. (FILE TOO BIG)
    I think we're going to need to see a file with your data structure.

    You don't have to post the real file. Just make up a SMALL file that demonstrates the structure and include the results you expect.

    10 to 20 rows and as few columns as possible is plenty of data.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    07-22-2014
    Location
    Philadelphia
    MS-Off Ver
    365
    Posts
    6

    Re: Display Column Header if any value other than 0 exists in a multi-column array.

    Sorry. Thank you.

    See attached. Formula in P2 for columns M,N,O.

    Also - some line have both Sand and Resin so this formula would need a variable to allow the result to be Sand/Resin in that case.

    Thanks again.
    John.

+ 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: 0
    Last Post: 01-14-2014, 06:35 PM
  2. [SOLVED] Match a value in a table and print the header of that column if value exists
    By norms in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2013, 06:48 PM
  3. Replies: 5
    Last Post: 09-12-2012, 01:27 PM
  4. Need Row and Column in Multi D Array
    By BeingYogi in forum Excel General
    Replies: 5
    Last Post: 04-04-2012, 10:57 PM
  5. Single Conditional Array x two Multi-Column Array - Approach needed
    By David Brown in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2010, 11:41 AM

Tags for this Thread

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