Search results 60

  2. Search results
  3. active year
Sorted from new to old.
Card image
SSL/TLS certificate add/update

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

Nov7
Card image
Quarter1stLastDate_FromQuarterText

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

Jul26
Card image
QuarterNumber_FromDate

Returns the number of quarter from a date

Jul26
Card image
Q_NoOfdays

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

Jun9
Card image
RangeValues

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

Jan25
Card image
CutString7

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

Jan1
Card image
ChartLabelsNumberFormat

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

2023Dec23
Card image
ANmaPivotTable_Clear

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

2023Dec22
Card image
ChartLegendCenter

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

2023Dec21
Card image
SQL Date from DateTime

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

2023Nov29
Card image
Latest records date and count

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

2023Nov2
Card image
BusinessDateDiff

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

2023Oct25
Card image
ANmaFilter3

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

2023Oct13
Card image
CopyDynamicRangeValue

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

2023Aug10
Card image
ANmaHTMLContent

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

2023Jul1
Card image
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11
1234