Create a series of workdays, excluding weekends and holidays
with No Comments

Create a series of workdays In this example I have written the function NextWorkDay that returns the next workday after the date you pass to the function. It makes it easy to create a series of dates that includes only workdays. … Read More

Using a scrollbar in the sheet
with No Comments

Using a scrollbar in Excel In this example we demonstrate the use of a scrollbar to scroll through a list of names. We also use IFERROR(), VLOOKUP(), MATCH(), COUNTIF() and a bit of VBA coding.   Download the workbook here: 

Using MATCH() and HLOOKUP() to find table value
with No Comments

This example is actually about trees. Håkon wants to input one value from a row and one from the heading and get the table value from the cell where the row and column intersect. So, like in the image, if he … Read More