Search results 69

  2. Search results
  3. columns
Card image cap
MatchIf (aka VMatchIf)

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

2018Jun16
Card image cap
GetColumnName, ColumnName_XOffset

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

2018Jun15
Card image cap
Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

2018Jun9
Card image cap
CountColumnCells + CountColumnCells_Criteria

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

2018May23
Card image cap
Webapp-ScrollAreas

Allow website to have scroll bars on areas, like a web app Applied in ANmar. ...

2018May19
Card image cap
SettingRead+SettingSave

This is the final version of my set of Setting functions SettingRead, ...

2018Apr27
Card image cap
DB_AllRows

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

2018Apr23
Card image cap
ArrayRead + ArraySave

Reading and saving 2 dim data into ANStrArray ANStrArray is a string ...

2018Apr15
Card image cap
DB_SettingRead + DB_SettingSave + ...

Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...

2018Apr14