Hello to all,
this formula:
in italian:
=SE($B$2="";"";SE(CONTA.SE($A$6:$A$206;"*"&$B$2&"*")=1;"trovato "&CONTA.SE($A$6:$B$206;"*"&$B$2&"*")&" articolo";
SE(CONTA.SE($B$6:$B$206;"*"&$B$2&"*")=1;"trovato "&CONTA.SE($B$6:$B$206;"*"&$B$2&"*")&" descrizione";
SE(CONTA.SE($A$6:$A$206;"*"&$B$2&"*")>1;"trovato "&CONTA.SE($A$6:$B$206;"*"&$B$2&"*")&" articoli";
SE(CONTA.SE($B$6:$B$206;"*"&$B$2&"*")>1;"trovato "&CONTA.SE($B$6:$B$206;"*"&$B$2&"*")&" descrizioni";
"nessun articolo/descrizione trovato")))))
in english:
=IF($B$2="","",IF(($A$6:$A$206,"*"&$B$2&"*")=1,"found "&COUNTIF($A$6:$B$206,"*"&$B$2&"*")&" article",
IF(COUNTIF($B$6:$B$206,"*"&$B$2&"*")=1,"found "&COUNTIF($B$6:$B$206,"*"&$B$2&"*")&" description",
IF(COUNTIF($A$6:$A$206,"*"&$B$2&"*")>1,"found "&COUNTIF($A$6:$B$206,"*"&$B$2&"*")&" articles",
IF(COUNTIF($B$6:$B$206,"*"&$B$2&"*")>1,"found "&COUNTIF($B$6:$B$206,"*"&$B$2&"*")&" descriptions",
"no found article/descritions")))))
The change is:
example:
in column A = hello
in column B = hello
in B3 = hello
in B2 = found 1 article / found 1 description
I hope I explained me.
max_max
-------------------------------------------------------------------------------------------------------------
Ciao a tutti,
questa formula:
in italiano:
=SE($B$2="";"";SE(CONTA.SE($A$6:$A$206;"*"&$B$2&"*")=1;"trovato "&CONTA.SE($A$6:$B$206;"*"&$B$2&"*")&" articolo";
SE(CONTA.SE($B$6:$B$206;"*"&$B$2&"*")=1;"trovato "&CONTA.SE($B$6:$B$206;"*"&$B$2&"*")&" descrizione";
SE(CONTA.SE($A$6:$A$206;"*"&$B$2&"*")>1;"trovato "&CONTA.SE($A$6:$B$206;"*"&$B$2&"*")&" articoli";
SE(CONTA.SE($B$6:$B$206;"*"&$B$2&"*")>1;"trovato "&CONTA.SE($B$6:$B$206;"*"&$B$2&"*")&" descrizioni";
"nessun articolo/descrizione trovato")))))
in inglese:
=IF($B$2="","",IF(($A$6:$A$206,"*"&$B$2&"*")=1,"found "&COUNTIF($A$6:$B$206,"*"&$B$2&"*")&" article",
IF(COUNTIF($B$6:$B$206,"*"&$B$2&"*")=1,"found "&COUNTIF($B$6:$B$206,"*"&$B$2&"*")&" description",
IF(COUNTIF($A$6:$A$206,"*"&$B$2&"*")>1,"found "&COUNTIF($A$6:$B$206,"*"&$B$2&"*")&" articles",
IF(COUNTIF($B$6:$B$206,"*"&$B$2&"*")>1,"found "&COUNTIF($B$6:$B$206,"*"&$B$2&"*")&" descriptions",
"no found article/descritions")))))
La modifica è:
esempio:
nella colonna A = ciao
nella colonna B = ciao
in B3 = ciao
in B2 = trovato 1 articolo / trovato 1 descrizione.
Spero di avermi spiegato.
max_max
Bookmarks