Search results 527

Sorted from new to old.

Min_No0s

Getting the minimum number from an array excluding zeros. Edit 2025-03-11: ...

2024Jun5

ANmAdd_ThenSort_2Columns

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

2024Jun1

MatchIf6Up

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

2024May31

MatchIf6

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

2024May31

MatchIf5Up

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

2024May27

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

2024May27

MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

2024Apr30

MatchIf2Up

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

2024Apr29

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

2024Apr17

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

MatchIfUp or MatchIfRev

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

2024Apr8

ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

2024Apr3

Concatenate_HTMLColumn

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

2024Mar14

Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

2024Mar4

CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

2024Feb27

1 2 ...7 ...32 33