Results 1 to 3 of 3

Find the first occurence of a value in range of cells & return the the column header label

Threaded View

  1. 09-09-2013, 05:32 PM #1
    bparrott
    bparrott is offline
    Registered User
    Join Date
    08-19-2013
    Location
    Santa Ana, California
    MS-Off Ver
    Excel 2010
    Posts
    5

    Find the first occurence of a value in range of cells & return the the column header label

    How can i find the first occurrence of a value in a range of cells. If the value is found then return the columns header label. If the value is not found, then return text "none".

    Attached spreadsheet with example data set.

    Thank you all!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find True in one of 3 columns and return column label
    By rnomis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-09-2013, 08:49 AM
  2. [SOLVED] How do I find the first occurence of a series of data in a range and return the value
    By bparrott in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2013, 07:05 PM
  3. [SOLVED] How do I return a header of column based on a range of cells containing specific data?
    By Dena in forum Excel General
    Replies: 6
    Last Post: 07-26-2012, 06:34 PM
  4. Find the row header and column label from a cell reference
    By Clddleopard in forum Excel General
    Replies: 3
    Last Post: 09-08-2011, 07:42 PM
  5. Find last numerical value in row range and return the column header
    By Fidd$ in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-04-2011, 10:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1