COUNTIF non-blank cells
last update: April 14, 2017Find the ISO weeknumber of a date
70 viewsShow most / least used text in a range
23 viewsSUMIF across multiple sheets
99 viewsCreating a list of unique values
69 viewsUse SUMIF on a column defined by MATCH
45 viewsDisplay sheetname in cell formula
24 viewsRound a figure to the nearest / highest 10,100,500 etc.
40 viewsConvert cell value to UPPERCASE or lowercase..
562 viewsConditional Graphic in Excel..
23 viewsUltimate Index: combine (nest) INDEX and MATCH..