Search results 91

Sorted from new to old.

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Apr18

VBA/Excel Registry hacks

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

Mar12

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2

Match4_4thNot0

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

2024Nov1

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

RegSave, RegRead, RegDelete

Windows Registry read, save and delete branch node or key. Three functions use ...

2024Sep15

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2

Q_NoOfdays

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

2024Jun9

CutString97

Cuts part from large string from certain character to certain character with ...

2024Jun5

Min_No0s

Getting the minimum number from an array excluding zeros. Edit 2025-03-11: ...

2024Jun5

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

2024May16

MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

2024Apr29

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

2024Apr8

1 2 ...5 6