Spreadsheets/ Google Fogli / Excel

As decimal separator (Separatore decimale) and thousands separator (separatore delle migliaia) ;

17.96 >>>>>U.S., the U.K, and Australia >>>(1,017.96)

17,96>>>>>Europe >>>>> (1'017,96)

Source= https://www.officetooltips.com/excel_2016/tips/change_the_decimal_point_to_a_comma_or_vice_versa.html

!!!! If you copy numbers from the gsheet and paste to excel you can face a difficulty. The source of error may be difference of the decimal separator. You must change your decimal separator or you must

Range in Excel: group of cells

https://www.ablebits.com/office-addins-blog/relative-absolute-reference-excel/#:~:text=The%20dollar%20sign%20in%20an%20Excel%20cell%20reference%20affects%20just,reference%20that%20won't%20change.

Dollar sign in Excel;First is for column (Il primo è per la colonna)

Second is for row (Il secondo è per la riga)

— —

Match Function

How do you give your range he returns according to it. If here is B4:B10 instead of B3:B10 it would return 3!!!

https://exceljet.net/functions/match-function

Match Function -Advance Level

https://corporatefinanceinstitute.com/resources/excel/match-function-formula/

OFFSET FUNCTION

https://tr.extendoffice.com/excel/functions/excel-offset-function.html#:~:text=Excel%20OFFSET%20i%C5%9Flev,h%C3%BCcre%20aral%C4%B1%C4%9F%C4%B1na%20bir%20ba%C5%9Fvuru%20d%C3%B6nd%C3%BCr%C3%BCr.

sparkline mini grafik Tek hücrede grafik!! Muhteşem özellik!!! Excel

www.datacamp.com

countifs — advance level

www.datacamp.com