Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
Creates list of items found in rows, where these rows match a value in another ...
2020May13
Quickly adds value to certain column in Excel sheet As usual, you can define ...
2020Jan3
Saves value to cell without deformation and converting Used to be called ...
2018Jun26
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Extract Date from Datetime field in SQL An old method I found in my archive.
Nov29
Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...
Aug8