Search results 235

Card image cap
ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Card image cap
MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

Card image cap
MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

Card image cap
MatchIf5Up

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

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Card image cap
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Card image cap
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Card image cap
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Card image cap
CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

CopyFiles.zip