Search results 75

Sorted from new to old.

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

Aug7

punycode

Encode or Decode Punycode used in domain names that are not in English ASCII ...

Jun8

ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

May24

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

May3

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

May2

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Mar12

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

Jan8

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

Excel 2408 bug

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

2024Sep10

Get boot time

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

2024Sep6

ANstr_Column

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

2024Jul29

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

CountRowCells

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

2024Jun22

Q_NoOfdays

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

2024Jun9

1 2 3 4 5