Search results 231

Sorted from new to old.

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

Wed 5AM

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

Wed 5AM

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

Nov25

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Nov18

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

1 2 ...14 15