Similar codes
SumOf_3Filters
Returns sum of certain column in range (or table) in sheet after applying ...
2021Jan29
ANmAdvancedFilter
Filter table inside Excel the fast way (using advanced filter) into another ...
2022Sep15
ANmaPivotTable_Clear
Clears all filters in PivotTable and hide the [blank] item from list, pass ...
Dec22
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Rows 2 Cell
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
SearchinHTMLTable
Search for a word in a certain column in html table and return the full row ...
Nov12
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Random Codes
HTML_CleanNumber
Cleans block of string (HTML block) from characters that are not needed Can ...
Jan31
Nearby Color shades
Calculate colors close to input color, a jquery html that will give you 10 ...
Nov8
