Search results 468

Sorted from new to old.
Card image
Match4

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

Card image
Match3

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

Card image
Match2

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

Card image
HMatchIf

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

Card image
MatchIf (aka VMatchIf)

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

Card image
Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

Card image
GetColumnName, ColumnName_XOffset

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

Card image
ANStrRead + ANStrSave + ANStrSearch

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

Card image
ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

Card image
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

Card image
Col2Combo

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

Card image
1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

Card image
Filter_GotoItem

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

Card image
Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

Card image
CutRightString

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

Card image
ANStrColor2RGB + RGB2ANStrColor

Converts R:G:B into RGB value (as long) and RGB from long into R:G:B