Jul 12 2021 01:13 PM
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!!!
Jul 12 2021 03:08 PM
Jul 12 2021 03:17 PM
Solution= 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.
Jul 12 2021 04:38 PM
Jul 12 2021 07:18 PM
Jul 12 2021 03:17 PM
Solution= 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.