+ Reply to Thread
Results 1 to 4 of 4

Stumped! How to create a Birthday Table

  1. #1
    Registered User
    Join Date
    10-28-2021
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    2

    Stumped! How to create a Birthday Table

    I encountered this Excel problem today that is way harder then I thought. The goal is to create a table (see Table sheet) of names who have birthdays that fall on a particular month and day. On the Birthday sheet there is a list of birthdays (the year can be ignored) along with their name in a separate column. So for example Billie Burke's birthday is on 4/5 so we would have "Billie Burke" written in cell E6 (for April 5th). Some cells may include multiple names; for example March 27th (E28) would contain the names "Arnold Stang, Benito Mussolini, Bill Maher" (how the names are separated doesn't matter).

    I initially tried an Index Match but it feels like it's actually doing the reverse and I couldn't figure out how to handle multiple names falling on the same birthday. Any guidance from folks here on how to best handle this?
    Attached Files Attached Files
    Last edited by DraconisA15; 10-29-2021 at 11:50 AM.

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,803

    Re: Stumped! How to create a Birthday Table

    1st, I changed the Month names at the top of Sheet "Table" to a date and formatted it to show the month name only. Then try this formula in cell B2:

    =IFERROR(TEXTJOIN(", ",TRUE,FILTER(Birthdays!$A$2:$A$501,(MONTH(Birthdays!$B$2:$B$501)=MONTH(Table!B$1))*(DAY(Birthdays!$B$2:$B$501)=Table!$A2))),"")

    Copy it across and down.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-28-2021
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Stumped! How to create a Birthday Table

    Wow awesome - definitely not something I would figured out on my own. Thank you!

  4. #4
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,803

    Re: Stumped! How to create a Birthday Table

    You're welcome, and thanks for the feedback and rep!

+ 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. [SOLVED] Generate a list of birthday persons from a table
    By gamenano in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-22-2021, 12:05 PM
  2. Calculated Field in Pivot Table - stumped
    By jimrosser in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-25-2015, 03:34 AM
  3. How to use data from one sheet to create a birthday calendar in another
    By mjpet06 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-24-2015, 09:27 PM
  4. Formula that shows the name and birthday of the youngest person in a table
    By Thomas11 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-11-2014, 09:56 AM
  5. searching Name day and Birthday in table
    By mastersoft in forum Excel General
    Replies: 3
    Last Post: 12-05-2010, 11:29 AM
  6. Stumped on how to create a horizontal line comparison chart
    By quaffin1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-25-2009, 08:39 AM
  7. Create a birthday list
    By Browneyes in forum Excel General
    Replies: 1
    Last Post: 02-15-2005, 10:58 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