Hi:
I'm having a problem with this Excel Formula: {=IFERROR(INDEX($G$5:$G$131, MATCH(0, IF($E$3=$F$5:$F$131, COUNTIF($C$4:$C4, $G$5:$G$131), ""), 0)),"")} used to extract the "Next Birthday" data in Column C after it was calculated in Column G based on the Birthday specified in Column E. The single criteria for the extraction is entered in Cell E3 (currently, shown as November in the attached example spreadsheet).
Ive used a similar formula to grab the names of all the people whose birthday falls in November (specified in Cell E3). That seems to work well.
But I cannot figure out why the "Next Birthday" formula in Column C isn't working well; particularly in Cells C11 thru C16 per the "November" criteria specified in Cell E3. Other criteria specification, such as "October", etc. produce similar issues.
I've attached a sample file. Please help fix the issue in the spreadsheet and note what has changed in the formula to fix the issue.
Any help to fix this issue is appreciated.
Thanks a million to all and thanks for this great forum.
I'm having a problem with this Excel Formula: {=IFERROR(INDEX($G$5:$G$131, MATCH(0, IF($E$3=$F$5:$F$131, COUNTIF($C$4:$C4, $G$5:$G$131), ""), 0)),"")} used to extract the "Next Birthday" data in Column C after it was calculated in Column G based on the Birthday specified in Column E. The single criteria for the extraction is entered in Cell E3 (currently, shown as November in the attached example spreadsheet).
Ive used a similar formula to grab the names of all the people whose birthday falls in November (specified in Cell E3). That seems to work well.
But I cannot figure out why the "Next Birthday" formula in Column C isn't working well; particularly in Cells C11 thru C16 per the "November" criteria specified in Cell E3. Other criteria specification, such as "October", etc. produce similar issues.
I've attached a sample file. Please help fix the issue in the spreadsheet and note what has changed in the formula to fix the issue.
Any help to fix this issue is appreciated.
Thanks a million to all and thanks for this great forum.