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?
Bookmarks