Reference column "Week" - Gantt

    Hi,


    I have a simple sheet for which I'd like to identify in which column ("Week") a specific number appears, is it in "Week 1", "Week 2" etc.?

    Can anyone help, please?

    I gave it a try with MATCH and XLOOKUP but to no avail.


    Book2.xlsx

    Thanks

    Power Query Solution


    Code
    let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Column1"}, "Attribute", "Value")
in
#"Unpivoted Other Columns"

    Hi Alan,


    thank you.
    Rather than a pivot, I'm looking for a formula that would return the correct column in a cell where I put the sentence "I'd like to know...". The reason for it is because I'm planning to use that value in another formula (i just simplified my spreadsheet to make it more obviuos what I'm trying to achieve).


    So, can you help me find a suitable formula for it, please?
    Thanks.

    Hi Carim,


    thank you for sharing your formula(s). I had a look at and it all makes perfect sense (now that I know the answer).

    I hope you can help me out in another thread I opened a few days ago (relating to gridlines in charts) - still waiting for someone to shed some light on that.


    Best regards!

    Thanks for your Thanks AND for the Like 8)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Haha 1

    Hi again,


    Same topic ... more or less ... ;)


    All the rows 7 to 19 do have the same structure as the one in you initial sample file.

    As a consequence, the formula you already have can easily be used ...


    As far as Row 6 is concerned, with a series of six steps located in the same row, most probably an Event macro will be required ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Forgot to mention, regarding Gantt, there are numerous free templates which could make your life easier...


    Googling for Excel Gantt templates will also guide you towards many YouTube videos ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Like 1

  • Carim

    Changed the title of the thread from “Reference of the column ("Week")” to “Reference column "Week" - Gantt”.

    Hello again,


    Just for the fun of it ... (sticking to your design) attached is your Test file with an Event Macro to generate your Gantt ... ;)


    Hope this will help :)

    Pleased to hear the Event macro helps ... :)


    Again, thanks a lot for your Thanks AND for the Like 8)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login