Search results 86

Sorted from new to old.

Match3_3rdNot0

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

Nov2

Match4_4thNot0

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

Nov1

ANmAddressRefStyle

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

Sep23

RegSave, RegRead, RegDelete

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

Sep15

CutString96_NumberX

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

Aug2

Q_NoOfdays

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

Jun9

CutString97

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

Jun5

ANmaHTMLTables_Combine2

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

May16

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

MatchIf2Up

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

Apr29

SortArea4

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

Apr15

MatchIfUp or MatchIfRev

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

Apr8

CutString11

Cuts long string from certain character to certain character with option to ...

Feb24

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

Feb5

ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

Feb4

1 2 ...5 6