Count matching strings using regular expressions

This article demonstrates a User Defined Function (UDF) that counts how many times a string exists in a cell value […]

Fetching values from ThingSpeak programmatically

  Picture above shows cheap chinese IoT modules: a temp sensor and an esp8266-01 (25 mm x 15 mm) Thingspeak […]

Extract cell references from a formula

This article demonstrates a User Defined Function that allows you to extract cell references from a formula in a given […]

How to use the LIKE OPERATOR

The LIKE operator allows you to match a string to a pattern using Excel VBA. The image above demonstrates a […]