Search results 33

Sorted from new to old.

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Jan1

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

CutString8

Cuts a string from certain character to certain character with option of either ...

2021May29

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

CustomExcelMenu - FaceIDs

How to create custom Excel menu, this one shows the IDs and icons of 20 icons, ...

2018Jul19

Match4

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

2018Jun16

Match3

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

2018Jun16

Match2

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

2018Jun16

HMatchIf

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

2018Jun16

MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

2018May29

1 2 3