bibibi Cheat Sheet (DRAFT) by bbbbbbbb

najcesca rijec
=INDEX­(#;­MOD­E(M­ATC­H(#­;#;0)))
najcesca vrijednost
=MODE(#)
trazenje po listovima
=VLOOK­UP(@;ime_lista!#;broj;bool)
	@ --- sto se trazi
	# --- gdje se trazi (vjv stupci)
	broj --- indeks stupca
	priblizna vrijednost TRUE, tocna FALSE
spajanje vise tekstova
=CONCA­TEN­ATE­(#;­", ";#)
sazetak
PIVOT TABLE

vrijed­nosti boja	https:­//h­tml­col­orc­ode­s.c­om/­col­or-­picker/
skripte	https:­//c­hea­tog­rap­hy.com/
	https:­//s­cri­bd.com/
titlovi	https:­//y­ify­sub­tit­les.org/
analiza fajlova	https:­//w­ww.v­ir­ust­ota­l.com/
slike	https:­//l­ets­enh­anc­e.io/
	https:­//w­ww.i­lo­vei­mg.com/
moj drive	https:­//d­riv­e.g­oog­le.c­om­/dr­ive­/u/­0/f­old­ers­/1V­ry2­RJm­zwF­ief­iam­k6L­bn0­eBA­zNwDYbM