Search results 196

Sorted from new to old.

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

2024Jul26

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

2024Jul24

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

2024Jun6

MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

2024May31

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

2024May31

MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

2024May27

MatchIf2Up

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

2024Apr29

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

MatchIfUp or MatchIfRev

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

2024Apr8

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

2024Feb25

1 2 3 ...12 13