Search results 146

  2. Search results
  3. start
Sorted from new to old.
Card image
Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9
Card image
Sort1Col

Sorts a column in Excel, easily, with options Expects ... Row 1 is header, ...

2018Jul4
Card image
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24
Card image
MatchIf_ThenDelete

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

2018Jun17
Card image
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16
Card image
Match3

Matching three values at the same time in three columns Just like Match the ...

2018Jun16
Card image
Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16
Card image
HMatchIf

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

2018Jun16
Card image
MatchIf (aka VMatchIf)

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

2018Jun16
Card image
BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14
Card image
Col2Combo

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

2018Jun10
Card image
CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2
Card image
CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

2018May29
Card image
CountColumnCells + CountColumnCells_Criteria

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

2018May23
Card image
ANmaHTMLTemplate

Index.html template having headers with Bootstrap v4.1 and Font-Awesome (BS4.1 ...

2018May22
Card image
List of options (Frm87)

Show list of items with their description from "Settings" sheet Have that list ...

2018May17
12...910