Search results 166

Sorted from new to old.

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

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

BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

CreditCardType

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

2023Jul28

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

LXFormat

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

2023Jun30

1 2 ...4 ...10 11