Some excel formulas
Cheatsheet for function translation (because functions change name with localization)
http://wwwhome.ewi.utwente.nl/~trieschn/excel/excel.html
Some useful functions
Domain in an email
Italian =STRINGA.ESTRAI(B4;RICERCA(“@”;B4)+1;LUNGHEZZA(B4))
English =MID(B4;SEARCH(“@”;B4)+1;LEN(B4))
Split string on first occurrence
First half
Italian =STRINGA.ESTRAI(E2;1;RICERCA(“,”;E2)-1)
English =MID(E2;1;SEARCH(“,”;E2)-1)
Second half
Italian =STRINGA.ESTRAI(C2;RICERCA(“,”;C2)+1;LUNGHEZZA(C2))
English =MID(E2;SEARCH(“,”;E2)+1;LEN(E2))
Absolute references
Put dollar sign before row/column to block it ($B$4 or $B4 or B$4)
Data classification trick for pivots
provide a reference sheet like param|value1|value2
and in the data sheet add columns which call the value from the reference sheet (FALSE is for exact match)
Italian =CERCA.VERT(A2;Config!$D$2:$F$58;2;FALSO)
English =VLOOKUP(A2;Config!$D$2:$F$58;2;FALSE)
sabas place 