Search results 30

Sorted from new to old.

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

2022Nov11

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

2021Dec30

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

2021Dec27

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

2021May29

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

2020May6

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

2019Jun12

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

2018Jul19

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

2018Jun16

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

2018Jun16

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

2018Jun16

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

2018Jun16

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

2018Jun16

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

2018May29

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

2018May23