Retrieve the column label based on the value of a row - Excel

Posted on 2012-09-14
Last Modified: 2012-09-18
I have the following table

                  Q1  Q2  Q3  Q4  BENEFIT_START
PROJECT 1   0     0     1    0
PROJECT 2   0     1     0    0

The number 1 indicates when the benefits start for a project. I would like to have a formula the puts the Quarter where benefits start under the column BENEFIT_START.  In the example above I would like to put Q3 next to project 1 and Q2 next to project 2
Question by:fitaliano
    1 Comment
    LVL 43

    Accepted Solution

    Assuming that the Qs are in row 1 enter this formula in row 2 and copy down



    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now