Excel consultant Ketil Øyesvold Melhus
I am a psychotherapist and system developer – where the common denominator for the two professions is diagnostics.
I am a psychotherapist and system developer – where the common denominator for the two professions is diagnostics.
Beware this is an unfinished project – and you are free to finish it. If you are looking for a out of the box invoice program, don’t download it – it’s not fully quality tested. If you are a VBA-developer, feel free and share your modifications with me. No, sorry, it doesn’t work on MAC…
When I want to add a new record to a table, I use the function CurrentRegion.Rows.Count and add 1 to the result to find the first empty row.CurrentRegion returns the contiguous range from a spesific cell. The contiguous range is the range from A1 in the case below – with no empty rows. Selecting CurrentRegion…
Usage example Function Code The function ffC is part of My Common Library:
Usage example Video sample Function code The function fR is part of My Common Library: My Common Library (1 download)
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…
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…