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 ...
hi Luxio1997
There is a way to get both values, but only if there are two values.
This is in spanish, you have to translate to italian or english.
=UNIRCADENAS("-";VERDADERO;TEXTO(BUSCARX(K10;J4:J8;K4:K8;"activo";0;1);"dd/mm/aaaa");TEXTO(BUSCARX(K10;J4:J8;K4:K8;"activo";0;-1);"DD/MM/AA"))
This formula find the first match from first to last row, and the second find match from last to first.
The only way I discorvered.
kind Regards