Search results 228

Sorted from new to old.

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Mon 5PM

SSL/TLS certificate add/update

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

Nov7

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

Nov3

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

Nov1

HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

Oct26

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

Oct24

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Sep10

Get boot time

Get the last time Windows 10 was started. Needed this quickly for research.

Sep6

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

Aug11

StartApp-IfNotStarted

Checks if application is already running, returns 1 or 0 My first function

Aug3

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

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

Jul25

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

Jun22

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Jun10

Q_NoOfdays

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

Jun9

1 2 ...14 15