Search results 60

Sorted from new to old.

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

ANmaRedirect

Simple redirecting function, used to direct users from one domain into another ...

2019Oct25

HTMLDecode + HTMLEncode

Decode and encode back a string using HTML Technically found online, but ...

2019Aug9

FilesKill

Delete Multiple Files (with WildCards) To delete multiple files from a ...

2019Aug7

More Bootstrap wells

Additional Bootstrap well colors, I always find it easier to use Wells (used in ...

2019Jun28

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

1 2 3 4