Search results 76

Sorted from new to old.

ANmaRemoveDuplicates2

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

Wed 5AM

ANmaRemoveDuplicates4

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

Wed 5AM

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

Nov17

ANmaSum_4IFs

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

Nov13

ANmAddress_Dimensions

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

Nov8

ANmAddress_Value

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

Oct31

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

ANmaFiles2List

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

Sep21

ANmaRead_1stFile

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

Aug11

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

Aug11

ANmaSearch_SpaceFriends and LeftSpaceFriends

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

Jul30

ANmaSearch_OrFriends

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

Jul30

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

Jul26

ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

Jul13

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

Jul13

1 2 3 4 5