Excel consultant Ketil Øyesvold Melhus
I am a psychotherapist and system developer – where the common denominator for the two professions is diagnostics.
Similar Posts
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)
Function findContent()
Find content in column1 with header xx, return value from same row in column2 with header yy. Note The function returns 0 (Zero) when value isn’t found, so you will not be able to distinguish between a found zero value, and value not found. So do not use if you have zero values in your…
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…
Excel VBA – Create and update Outlook Calendar Items
With the Sub UpdateAppointment you can create and update Outlook meetings or appointments. All items must have a unique index to filter on. The sub filters on BillingInformation, a field I rarely use for other purposes. Appointments The appointments are created in your personal calendar. If you want to put stuff in others calendar, you…
Function ffC() – Find first free column in first row
Usage example Function Code The function ffC is part of My Common Library:
Excel VBA: Subroutines for speed optimization
Sub AppOnOff Sub AppEv Sub AppCal Sub AppSc You can download the Excel workbook with the sample code at the end of this Article Sub AppOnOff AppOnOff true – turns off Events, Automatic Calculations and ScreenupdatingAppOnOff false – turns them back on AppEv, AppCal and AppSc turns Events, Automatic Calculations and Screenupdating on/off individually When…