Search results 60

Sorted from new to old.

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

2018Jun26

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

2018Jun16

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

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

2018Jun16

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

2018Jun15

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14

Reads everything in a column (starting from certain cell until blank cell is ...

2018Jun10

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

2018May23

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

2018Apr27