Code and Data Manipulation

Find and Replace with Regex

Regex to find date and time. Option 1: ([\d]{1,2})/([\d]{1,2})/([\d]{4}) in format mm/dd/yyyy O...

Find Data in Cell

This document is in development SEARCH finds "text value" in cell A1. IF result of SEARCH is th...

Count Unique Values in Spreadsheet

This document is in development UNIQUE finds the unique values in a spreadsheet row or column. ...