Creates list of unique items found in a column, returns string with items ...
2020May6
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
Replace strings found in list of strings from inside a string, does taht make ...
Nov11
Creates list of items found in rows, where these rows match a value in another ...
2020May13
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan23
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
Checks if a workbook is found in a SharePoint location or not, giving a full ...
2020Apr1
MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...
2019Feb1