Search results 106

Sorted from new to old.

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Oct6

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

Sep5

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

Sep3

CountNumbers_inString

Returns how many numbers found inside a text

Aug1

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

Jul26

DecimalPlaces

Returns how many decimal places the number have

Jul24

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

Jul18

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

Jul13

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

Jun22

JSON_To_Table

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

Jun6

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

SortArea4

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

Apr15

Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

Mar23

VBInstr_Numeric

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

Feb25

EdgarCIK

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

Feb25

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

Feb23

1 2 ...6 7