Search results 295

Sorted from new to old.

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Mon 5PM

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

Sun 7AM

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

Nov13

Sheet_RowID_Generate + _LastUsed

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

Nov3

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

Nov3

GetPapa + GetSon with variances

Gets the parent folder full name from a path Also Gets the son of a full path. ...

Oct26

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Oct6

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

Sep24

Get boot time

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

Sep6

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

Sep5

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

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

Jul29

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

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

1 2 ...18 19