Search results 571

  2. Search results
  3. function
Sorted from new to old.
Card image
AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1
Card image
HMatchIf_Multi

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

2023Oct30
Card image
BusinessDateDiff

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

2023Oct25
Card image
ANmaNumber_Closest2Word

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

2023Oct24
Card image
ContainerHTMLTag_Index

Returns location of the tag that enclosing the location provided inside HTML ...

2023Oct22
Card image
ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21
Card image
BusinessDateAdd

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

2023Oct11
Card image
Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7
Card image
Any2Dec

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

2023Sep20
Card image
SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3
Card image
NumberFoundinsideTag

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

2023Aug21
Card image
FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15
Card image
Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

2023Aug14
Card image
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10
Card image
WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

2023Aug9
Card image
Total14Round

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

2023Aug8
12...10...3536