Random codes

Similar codes

HMatchIf

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

2018Jun16

ANmarAmdeen

TextPercentageMatch

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

2018Jun26

ANmarAmdeen

Match4

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

2018Jun16

ANmarAmdeen

Match2

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

2018Jun16

ANmarAmdeen

MatchIf_ThenDelete

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

2018Jun17

ANmarAmdeen

Match3

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

2018Jun16

ANmarAmdeen

CountColumnCells + CountColumnCells_Criteria

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

2018May23

ANmarAmdeen

MatchIf2Up

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

Apr29

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Recently by developer

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

ANmarAmdeen

MatchIf2Up

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

Apr29

ANmarAmdeen

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-01-02: Adding ability to ...

Nov12

ANmarAmdeen

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

ANmarAmdeen

JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

2020Jul30

ANmarAmdeen

SQL Join

Different types of join in SQL. A good illustration image i found during my ...

2018Aug31

ANmarAmdeen