Finds last occurrence of a match in a column Finds the row of last time an ...
2019Jun12
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
Counts how many cells matching 2 criterias.
Just like
May1
Creates list of unique items found in a column, returns string with items ...
2020May6
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
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
A bootstrap mega menu
Demo:
2019May12
Calculates the area of objects. Pass formula argument as string and values as ...
2018Jul24
Converts SharePoint URL to regular folder path and the other way, giving the ...
2018Jun30