Get Digital Help
  • Home
  • Functions
  • Charts
  • Formulas
  • Products
  • Archive
  • Contact
  • About Me
    • About me
    • Blogs I read
    Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel Course

    Most used functions

    COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP function


Count matching strings using regular expressions

A regular expression is a pattern containing specific characters to search for sub-strings in strings. The patterns are at first […]

Fetching values from ThingSpeak using vba

Thingspeak is web service that allows you to upload and store data from IoT devices. Picture above shows cheap chinese […]

Extract cell references from a formula

I am trying to build a regular expression that matches cell references in a formula. A regular expression is a […]

Working with the LIKE OPERATOR

The LIKE operator allows you to match a string to a pattern in excel vba. The following characters are specifically […]

      Formula categories

      Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup
  • Welcome! I am Oscar and here to help you!

    Feel free to comment and ask Excel questions.

    Don´t forget to add my RSS feed and subscribe to new blog articles by email.

  • Free Blog Emails

  • Search website