Search for a word in a certain column in html table and return the full row ...
Nov12
Creates HTML file using template found in a column. Have lines of HTML in a ...
2022Feb5
Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...
2018Jun15
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
Concatenate all rows found in a range starting A1Cell for Columns_To columns ...
2023Mar6
Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Cuts a string from certain character to certain character with option of either ...
2021May29
Get the ID of the last inserted record in a table. There are other methods, ...
2019Jul18