Search results 81

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

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

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

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

MatchIf2Up

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

Apr29

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

NumberBeforeString

Cuts a number that would be found before certain word inside a block string. ...

Feb1

1 2 ...5 6