Cerca.x

%3CLINGO-SUB%20id%3D%22lingo-sub-2698679%22%20slang%3D%22en-US%22%3ECerca.x%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2698679%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3EHo%20provato%20questa%20nuova%20funzione%2C%20ma%20senza%20un%20risultato%20positivo.%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3Ese%20sostituisco%20la%20colonna%20di%20ricerca%20con%20un%20testo%20alfanumerico%20mi%20da%20il%20risultato%2C%20ma%20se%20la%20colonna%20di%20ricerca%20come%20nel%20mio%20caso%20%C3%A8%20struttura%20da%20numeri%20decimali%2C%20non%20restituisce%20il%20risultato%20sperato.%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3EPotete%20aiutarmi%20a%20capire%20dove%20sbaglio%3F%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3Egrazie%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2698679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Ho provato questa nuova funzione, ma senza un risultato positivo.

 

se sostituisco la colonna di ricerca con un testo alfanumerico mi da il risultato, ma se la colonna di ricerca come nel mio caso è struttura da numeri decimali, non restituisce il risultato sperato.

Potete aiutarmi a capire dove sbaglio?

 

grazie

 

1 Reply

@onidale The "numbers" in column A were in fact texts. I've transformed them to real numbers, just like the number in F1. Now the formula works as intended. See attached.