CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

Most recent in Oracle DB

List the most recently added rows based on a date column.

CSS Charts

Great articel about making charts in CSS. It has 3 main types, bar, column, ...

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

Tabulator

A nice, advanced powerful table control in js From

tabulator-master.zip

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...