Forum Discussion
CHOOSING A VALUE FROM HOMONYMS
Hello everyone. I'm going crazy trying to find a formula that allows me to choose a certain value between homonyms. I'll get into the specifics. In the image below, in column A, I have Surname ...
if you want both
| 2000-05-16,1997-01-20 |
=TEXTJOIN(",",TRUE,FILTER(TEXT(B1:B2,"e-mm-dd"),A2:A2=A4))
- I would like that when I enter a name, if it is already present, it should give me the opportunity to choose the one with the date of birth I choose.
- https://club.excelhome.net/forum.php?mod=viewthread&tid=567518&extra=&mobile=
Data picker like this?
Prepare key code is the Date and description is full name?I'm attaching the file so it's easier to understand.
