Returns sum of certain column in range (or table) in sheet after applying ...
2021Jan29
Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...
Nov13
Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...
Jul29
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
Remove duplicated rows based on 2 columns in a table of any number of columns. ...
Dec4
Counts how many cells with data in a row, starting from certain column until ...
Jun22
Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...
Feb2
Downloading file directly to machine without refreshing or going to another ...
Jul27