Bold.Codes

Search results 145

Counts how many cells matching 2 criterias. Just like

Wed 7AM

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

Mon 9AM

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

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

Apr18

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

Apr15

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

Apr8

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

Feb25

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

Feb23

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Jan23

Shows or hides an item or items in a PivotTable filter field. Passing ...

Jan22

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23