Search results 63

Sorted from new to old.

MatchIf2Up

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

2024Apr29

MatchIfUp or MatchIfRev

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

2024Apr8

VLookup_HTML

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

2024Jan26

ConcatenateStrings_AmongString

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

2024Jan17

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

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

SQL Related posts

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

2022Jul6

RowList_Matching

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

2021Dec27

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

HasDups

Indicates if an array contains duplicate values. returns True if more than one ...

2019Oct5

ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...

2019Jun28

1 2 3 4