Search results 60

Sorted from new to old.

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

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

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