Random codes

Codes Required

Similar codes

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

Nov1

ANmarAmdeen

Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

Nov13

ANmarAmdeen

Match2

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

2018Jun16

ANmarAmdeen

MatchIf6Up

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

May31

ANmarAmdeen

HMatchIf

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

2018Jun16

ANmarAmdeen

MatchIf6

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

May31

ANmarAmdeen

MatchIf5Up

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

May27

ANmarAmdeen

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

ANmarAmdeen

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

ANmarAmdeen

Recently by developer

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

Jan12

ANmarAmdeen

ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Jan12

ANmarAmdeen

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

Jan8

ANmarAmdeen

ANmaSum_5IFs

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

Jan8

ANmarAmdeen

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Aug20

ANmarAmdeen

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

Aug7

ANmarAmdeen

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

ANmarAmdeen

Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

2018Jun16

ANmarAmdeen