Similar codes

Card image cap
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

Card image cap
TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

Card image cap
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16

Card image cap
Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

Card image cap
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

Card image cap
Match3

Matching three values at the same time in three columns Just like Match the ...

2018Jun16

Card image cap
CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

Card image cap
MatchIf2Up

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

Mon 9AM

Card image cap
File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

Recently by developer

Card image cap
MatchIf2Up

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

Mon 9AM

Card image cap
ANString_Location

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

Tue 8AM

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

Card image cap
ANmaCellFormat

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

Apr18

Random Codes

Card image cap
XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

Nov26

Card image cap
Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

2018Jun10