Excel consultant Ketil Øyesvold Melhus
I am a psychotherapist and system developer – where the common denominator for the two professions is diagnostics.
Similar Posts
Excel VBA: Create a series of workdays only
The Nextworkday(date, optional holidays) function returns the date for the next workday. The first parameter is the starting date you set manually.The second parameter is optional and points to a range with dates you want to exclude from the workdays list, like easter or your vacation.If you omit the second parameter, only Saturdays and Sundays…
Excel VBA: Working with shapes and Pythagoras
This was a fun exercise. How to place a random number of dots on a circles circumference with exact the same distance between them? The need arose building a program for automated seating. Rectangular tables were no big deal, but what about the round tables? You can download the workbook at the bottom of this…
Function ffC() – Find first free column in first row
Usage example Function Code The function ffC is part of My Common Library:
Function fR() – Return row number where Content is found in Column with specified Header
Usage example Video sample Function code The function fR is part of My Common Library: My Common Library (1 download)
Excel VBA: CopyUsedRangeValues – fastest way to copy values from sheet to sheet.
RunCopyUsedRangeValues will copy the values from the sheet with codename shSource to shDestination. It is extremely fast, and very useful when I don’t need formatting or formulas. You can download the Excel workbook at the bottom of the article Usage example The source and destination sheets can be in the same or in separate workbooks…
Hour registration in Excel with calculation of time within intervals
If you work from 20:15 to 02:30 on a Saturday, how many hours are in the interval 15:30 to 00:00, and what should you be paid? The function HoursInInterval() can give you the answer and calculate your wage correct depending on it’s a weekday, weekend or a holiday. You can download the workbook at the…