Search results 70

Sorted from new to old.
Card image
MatchIF5

Searching for rows having 5 values in 5 columns Like

Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Card image
MatchIf2Up

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

Card image
MatchIfUp or MatchIfRev

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

Card image
VLookup_HTML

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

Card image
ConcatenateStrings_AmongString

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

Card image
ANStrFind_AndOrAdd

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

Card image
IfFoundInList

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

Card image
LXFormat

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

Card image
ANmaVLookup

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

Card image
SettingNameAlreadyFound

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

Card image
FoundinList

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

Card image
SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

Card image
BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

Card image
RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

Card image
HTMLTagAttributeValue

Reads value of certain tag attribute from certain attribute Identify attribute ...