Search results 342

Sorted from new to old.

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

2024Jan30

RangeValues

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

2024Jan25

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24

PivotTable_ShowHideItems

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

2024Jan23

PivotTable_ShowHideBlankItems

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

2024Jan22

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

2024Jan8

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

2023Dec29

ChartLabelsNumberFormat

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

2023Dec23

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

Webfont generater

Online tool. Generate web font to be used in websites. When trying to fix ...

2023Nov27

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

HMatchIf_Multi

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

2023Oct30

ContainerHTMLTag_Index

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

2023Oct22

1 2 ...4 ...21 22