Recent content by giovanni9720

Still is not what i need , i would like to create the formula and dont touch it any more , with methods you show me each day i should drag the formula, i need an array formula that fills all the column automatically, more or less like "=arrayformula(if a2 a <>"", sum b2 b , "") But i cant use...

I would like a formula that i dont Need to drag each time, Sum b2 b7 Is not the solution i am looking for, thanks anyway for your time :

OBJECTIVE : automated cumulative sum . . Hi all, I would like to get the same values contained in column a, but using a formula array so that I don’t have to drag the formula every time, I tried with rif row and row but failed, can anyone help me? . A2 contains sum b2 b A3 contain sum b3 b...

i solve the problem with this formula =arrayformula( ifs( VAL.VUOTO(L5:L); SE.ERRORE(1/0); VAL.NUMERO(L5:L); VALORE(L5:L); VAL.NUMERO(SE.ERRORE(VALORE(SOSTITUISCI(regexreplace(L5:L; "\.(\d\d)$"; ",$1"); "."; "")))); VALORE(SOSTITUISCI(regexreplace(L5:L; "\.(\d\d)$"; ",$1"); "."; "")); VERO; L5:L...

INCOLLA SPECIALE SOLO TESTO SU APPLE . salve, mi sono appena accorto che sui dispositivi apple non è disponibile l'opzione "incolla speciale" , "solo testo", come posso fare? . c'è da qualche altra parte? grazie mille

i try to attach the file but it appear the spam error, i dont know why i cant format the column because this file is done to extract the amount extract of the bank and different banks export amount in different ways so i am looking to a way that works for every type of amount that i paste in...

WRITE ALL THE AMOUNT IN THE SAME WAY . in the column "AMOUNT" OF THE FILE https:/ / /docs.google.com/spreadsheets/d/1Sh86J7ChtibaRpNHugURH4ybBBZlXDDpR9np0IQfOd9w/edit?fbclid=IwAR0qTKQ30P6tJuq7ux7uxO11UcSt88qPhG7Wkic2Uc77fNcY1x7x2fcyJgNgid#=799112 . in the sheet "daily" I would like to show up...

other forum suggest me this formula that works . =arrayformula( SE.ERRORE( CERCA.VERT( regexextract(B5:B; textjoin("|"; VERO; leggenda!B5:B)); leggenda!B5:C; COLONNE(leggenda!B5:C); FALSO ); SE( LUNGHEZZA(B5:B); "scrivi qui a sinistra"; SE.ERRORE(1/0) ) ) ) . you can see it in the cell...

my contents appear like spam, where can i link the google sheet file? thanks

EXTRACTS IF CONTAINS . The goal is to get the same result obtained in column D of the sheet "daily" but with a more decent formula and that allows me to add more data to the legend without having to put my hand to the formula every time . What should the formula do? Look at column B of the...

hello, i am giovanni, i love numbers and i want to work with google sheet, i hope i can help the community to grow up as much as i can see you soon