Similar codes
CreateUniqueList
Create list of unique items from a column into another column This is similar ...
2022Apr26
CreateList_Matching
Creates list of items found in rows, where these rows match a value in another ...
2020May13
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
2020May6
RemoveDuplicates
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
Recently by developer
Animated placeholders
White and dark animated placeholders to be used in websites. I needed to ...
Mon 4PM
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
VBInstr_Occurance
Returns location of text inside another with jump ability for any certain ...
Dec1
Random Codes
ANmaHTMLTables_Combine2
Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...
May16
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Hiding chart in Excel
How to hide a full chart in Excel. By treating it as shape, not as chart.
2020Dec31
