Get The Workbook And Sheet Name With A Formula
These formulas require that the workbook is saved
Recent posts
Generate A List Based On Criteria
Generate a list of items based on a criteria that doesn’t show any blanks or spaces. 20 Fruits and Vegetables listed below, choose either a fruit or vegetabl...
Index And Match
This tutorial demonstrates the key strengths of Excel’s INDEX / MATCH function that make it superior to VLOOKUP. You will find a number of formula examples t...
Formula To Create A Guid
A GUID (or UUID) is an acronym for ‘Globally Unique Identifier’ (or ‘Universally Unique Identifier’). It is a 128-bit integer number used to identify resourc...
Convert Decimal To Total Hours And Minutes
When converting a decimal to hours and minutes, ensure to use the correct Number Format.