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
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
Matching any part of a string in another , then returns 0 if not match, Or ...
2018Jun26
Searches for an item in a column, then if found, delete that cell (not clear, ...
2018Jun17
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Ranks a number among set of numbers. This is part of huge tool, we needed to ...
2021Sep23
Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...
2018Jul7