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
Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...
2021Oct5
Cleans array of unwanted items This usually needed after you merge two arrays, ...
2021Sep22
Creates list of items to be used in ' Where item in (List)' list Mainly adds ...
2020Jan6