Search results 128

Sorted from new to old.

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

CreditCardType

Returns credit card type and whether it is valid or not. Found it in my old ...

2023Jul28

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

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

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

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

BooleanCount

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

2022Apr22

RowList_Matching

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

2021Dec27

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

1 2 ...5 ...7 8