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