Search results 300

Sorted from new to old.

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

Jun9

CutString97

Cuts part from large string from certain character to certain character with ...

Jun5

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Jun1

MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May31

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31

MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

May27

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Apr8

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14

Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

Mar5

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

Feb25

CutString11

Cuts long string from certain character to certain character with option to ...

Feb24

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

Feb23

1 2 ...4 ...18 19