Search results 44

Sorted from new to old.

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

MathInsideText

Return string after applying math to each number found inside the string. ...

2025May8

MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

2025May7

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

2025Apr12

ListItemText_to_ListIndex

Finds the index of an item in listbox (or combobox) It searches for that item ...

2025Mar24

ANmaRename2Files

Quick batch file to rename two files. One of my big sources of images for my ...

2025Mar16

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

2025Mar10

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

2025Feb26

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

2025Jan8

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2

1 2 3