Excel Formulas

COUNTIF non-blank cells
last update: April 14, 2017
 Find the ISO weeknumber of a date
71 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
25 views
 Round a figure to the nearest / highest 10,100,500 etc.
43 views
 Convert cell value to UPPERCASE or lowercase..
592 views
 Conditional Graphic in Excel..
45 views
 Ultimate Index: combine (nest) INDEX and MATCH..
76 views