Search results 61

Sorted from new to old.

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

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

MatchIf2Up

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

Apr29

MatchIfUp or MatchIfRev

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

Apr8

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Jan26

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

Jan17

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

1 2 3 4