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

RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

2024Oct1

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

Int function in ASP Classic (cint vs fix)

If you are looking for a function ASP Classic (VBScript) to do what Int() does ...

2024Feb6

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

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

ANmaRemoveDuplicates

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

2022Sep25

RemoveDuplicates

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

2022Jul7

1 2