Search results 108

Sorted from new to old.

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

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

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

2018Jun10

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

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

2018Apr27