Search results 60

Sorted from new to old.

SSL/TLS certificate add/update

Always found myself struggling when applying security to websites for the past ...

Nov7

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

Aug11

Quarter1stLastDate_FromQuarterText

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

Jul26

QuarterNumber_FromDate

Returns the number of quarter from a date

Jul26

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

Jun9

MatchIfUp or MatchIfRev

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

Apr8

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Jan1

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

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25

ANmaFilter3

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

2023Oct13

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

1 2 3 4