Search through a two-dimension Matrix with the VLOOKUP-Function
Jan 5, 2021
Add comment
With a user defined function, determine text, address and sub address of a hyperlink.
Dec 15, 2020
Add comment
Ascertain if a File exists in a Directory
Dec 14, 2020
Add comment
VLOOKUP on a Closed Workbook
Dec 13, 2020
Add comment
Construct an Array Formula in VBA
Dec 13, 2020
Add comment
Auto Update Sorted List
Dec 13, 2020
Add comment
XLOOKUP FUNCTION
Dec 11, 2020
Add comment
How to Compare Two Data Ranges in Excel
Jan 30, 2018
Add comment
Convert all external links from formulas into values
Jan 5, 2018
Add comment
Extract Year from Text
Dec 28, 2017
Add comment
Hide Empty Rows on Print
Dec 24, 2017
Add comment
Create an Access File from within Excel File
Dec 23, 2017
Add comment
Sort by Frequency
Dec 15, 2017
Add comment
Conditional Formatting with VBA
Dec 14, 2017
Add comment
User Defined Function (UDF): How can I ascertain if two fields have identical Values?
Dec 14, 2017
Add comment
List Dates and Week Number
Dec 14, 2017
Add comment
How can I make Excel ask for a Start- and Enddate via an InputBox and then mark both dates colored?
Dec 14, 2017
Add comment
Array Function
Dec 14, 2017
Add comment
INDIRECT FUNCTION
Dec 13, 2017
Add comment
INDEX and MATCH Function
Dec 8, 2017
Add comment
Dynamically Refreshing Pivot Tables
Dec 6, 2017
Add comment
SAP Analysis Office on Excel
Dec 6, 2017
Add comment