Excel Formulas

COUNTIF non-blank cells
last update: April 14, 2017
 Find the ISO weeknumber of a date
78 views
 Show most / least used text in a range
23 views
 SUMIF across multiple sheets
109 views
 Creating a list of unique values
70 views
 Use SUMIF on a column defined by MATCH
48 views
 Display sheetname in cell formula
26 views
 Round a figure to the nearest / highest 10,100,500 etc.
44 views
 Convert cell value to UPPERCASE or lowercase..
593 views
 Conditional Graphic in Excel..
47 views
 Ultimate Index: combine (nest) INDEX and MATCH..
77 views