Search results 60

Sorted from new to old.

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

2018Aug16

Shows a chart with links, nice sitemap maybe, or just easy way to show ...

2018Aug14

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 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

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