I have all the data needed but am struggling to create a working formula to show significant birthdays.
AA6:AA203 has ages as at 31 Dec
B6:B203 has everyone's names
C6:C203 has everyone's DOB
I think I'm wanting to identify the nth occurrence of column AA range ending in a 0, then return their name and their DOB. Ideally, if the formula could include significant birthdays of 18 and 21 as well as ones ending in 0, that would be amazing! I've been trying to avoid array formulas. Any assistance would be brilliant!
AA6:AA203 has ages as at 31 Dec
B6:B203 has everyone's names
C6:C203 has everyone's DOB
I think I'm wanting to identify the nth occurrence of column AA range ending in a 0, then return their name and their DOB. Ideally, if the formula could include significant birthdays of 18 and 21 as well as ones ending in 0, that would be amazing! I've been trying to avoid array formulas. Any assistance would be brilliant!