Search results 60

Sorted from new to old.

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

2018Aug25

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

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

2018Jun17

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

2018Jun16

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

Allow users to select from list box based on search terms. Have a text box and ...

2018Jun7

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

2018May17

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

2018Apr23

Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...

2018Apr14