Search results 546

Sorted from new to old.

ANmaSum_4IFs

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

Nov13

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

Nov10

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

Nov8

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

Oct31

MaxOfArray

Gets the maximum number from an array. Like

Oct24

CountColumnCells_Unique

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

Oct6

RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

Oct1

Excel 2408 bug

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

Sep10

QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

Aug15

Code128.js

Pure JavaScript library for generating barcodes using HTML5 canvas.

Aug13

HTMLRow_Cell

Returns column with ColumnID ... the full area between < td ...> and < /td> ...

Aug4

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

Jul27

DateDiff_Networkdays

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

Jul25

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5

MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

May27

1 2 ...34 35