+ Reply to Thread
Results 1 to 5 of 5

Getting Name project According to the Number Day

  1. #1
    Forum Contributor
    Join Date
    05-21-2019
    Location
    Tabriz,Iran
    MS-Off Ver
    2010
    Posts
    184

    Getting Name project According to the Number Day

    Hi,

    Input

    g1.jpg


    Output expected

    g2.jpg
    g3.png
    g4.png


    Regards,
    Jacob
    Attached Files Attached Files
    Last edited by Yaghoub61; 04-09-2020 at 03:15 AM.
    Notice:
    my main language is not English

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Getting Name project According to the Number Day

    Please try at D2
    =IF($B2="","",IFERROR(INDEX(Main!$A:$A,AGGREGATE(15,6,ROW($B$2:$B$7)/(INDEX(Main!$B$2:$D$7,,MATCH($B$1,Main!$B$1:$D$1,))=$B2),COLUMNS($D2:D2))),""))
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-21-2019
    Location
    Tabriz,Iran
    MS-Off Ver
    2010
    Posts
    184

    Re: Getting Name project According to the Number Day

    @Bo_RY, Your job is so so Nice and Awesome!!!

    One Mellion Thanks for your great help

  4. #4
    Forum Contributor
    Join Date
    05-21-2019
    Location
    Tabriz,Iran
    MS-Off Ver
    2010
    Posts
    184

    Re: Getting Name project According to the Number Day

    Hi,

    I need conditional formatting based on the value 1 into A column of each Month

    Input
    g5.gif
    Output:
    g6.gif
    The Best,
    Jacob
    Attached Files Attached Files
    Last edited by Yaghoub61; 04-08-2020 at 08:54 AM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Getting Name project According to the Number Day

    Please start a new thread with an appropriate title for this new request. Thanks.

    All participants: no further help in this thread, please.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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: 3
    Last Post: 08-11-2017, 03:10 AM
  2. Replies: 1
    Last Post: 06-12-2017, 09:20 PM
  3. Replies: 2
    Last Post: 05-10-2017, 07:32 PM
  4. Replies: 1
    Last Post: 05-02-2014, 03:05 PM
  5. Match Column A's Project number to change based on greater number in new row
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2013, 10:18 AM
  6. Linking a project name to a project number
    By tvg543 in forum Excel General
    Replies: 2
    Last Post: 11-08-2012, 04:39 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