Forum Discussion
Multiple dates in Birthday List
I have a list of birthdays for family & friends and, of course, some have the same date. I use this formula ( =XLOOKUP(E1,F9:F110,B9:B110,"NONE",2)&" "&XLOOKUP(E1,F9:F110,A9:A110," ",2) ) to locate a name that matches TODAY() (E1) AND the year they were born in (to display their age). My question is how do I modify the formula to find multiple, or all, dates the meet the criteria? Thanks in advance!!!
= FILTER(IF({0,1},Name, Age), Birthday=today, "None")
The blue combines the two columns into a 2D range, reversing their order. FILTER then picks out the matching birthdays. You could also add a SORT to list the individuals in age order.
5 Replies
= FILTER(IF({0,1},Name, Age), Birthday=today, "None")
The blue combines the two columns into a 2D range, reversing their order. FILTER then picks out the matching birthdays. You could also add a SORT to list the individuals in age order.
- Why do you use XLOOKUP and not FILTER?
- XLOOKUP just seemed the easier way to go...never even considered FILTER
