Search results 26

Sorted from new to old.

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Apr18

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

Apr17

String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

Apr10

String_S

Generate repeated text, like String() the function but with ability to repeat ...

Apr10

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

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

2024Feb18

OutlookFolder_DuplicatesRemove

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

2023Jan1

OutlookFolder_DuplicatesCount

Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...

2022Dec31

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

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

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

1 2