Search results 95

Sorted from new to old.

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

2025Feb26

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

2025Jan8

ANmaSum_5IFs

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

2025Jan8

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

ANmaSum_4IFs

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

2024Nov13

ANmAddress_Dimensions

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

2024Nov8

ANmAddress_Value

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

2024Oct31

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

ANmAddressRefStyle

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

2024Sep23

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

2024Sep21

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11

ANmaSearch_SpaceFriends and LeftSpaceFriends

Searches for string inside string covering multiple possibilities for space ...

2024Jul30

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

2024Jul30

1 2 ...5 6