Search results 60

Sorted from new to old.

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

Sorts a column in Excel, easily, with options

2018Jul4

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26

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

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

2018Jun2

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

2018May23

Returns all rows found from an SQL Query as string Separated by row and column ...

2018Apr23