Category: Standard functions

Standard functions that comes with Excel, plain single functions

New function IFERROR, finally

ANmar December 24, 2017

OFFSET+MATCH

ANmar June 9, 2017

Count how many times letter found

ANmar March 3, 2017

Calculate hours between two cells

ANmar February 27, 2017

MATCH fumction, just a simple search

ANmar February 20, 2017

Multiple lines in cell using functions

ANmar December 2, 2016

Links between two workbooks – dynamically using functions

ANmar September 26, 2016

VLookup

ANmar September 26, 2016

CONVERT function

ANmar September 26, 2016

Workdays – Across months

ANmar November 3, 2015

Extract current (Active) workbook name

ANmar September 14, 2015