Search results 341

Sorted from new to old.

RangeValues

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

Jan25

VBInstrRev

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

Jan24

PivotTable_ShowHideItems

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

Jan23

PivotTable_ShowHideBlankItems

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

Jan22

SettingRead_JSON

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

Jan8

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

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

1 2 ...4 ...21 22