Searching for an item in a column from bottom to top. Will search for item in ...
Apr8
Returns column if an item from list of items was found in a row. Similar to ...
Oct30
Searches for an item in a column, then if found, delete that cell (not clear, ...
2018Jun17
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
Matching any part of a string in another , then returns 0 if not match, Or ...
2018Jun26
Checks if number between two numbers, with or without considering those numbers. ...
Mar23
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
Concatenate all rows found in a range starting A1Cell for Columns_To columns ...
2023Mar6
Cuts a string from certain character to certain character with option of either ...
2021May29
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1