Random codes

Similar codes

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

ANmarAmdeen

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

ANmarAmdeen

SumOf_3Filters

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

2021Jan29

ANmarAmdeen

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Dec22

ANmarAmdeen

Sieve

jQuery plugin to search filter content, customize, easy to apply From

2019Jul10

ANmarAmdeen

jQuery filtering

jQuery filtering, demo From

2019Jul9

ANmarAmdeen

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Jan22

ANmarAmdeen

ANmaRemoveDuplicates

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

2022Sep25

ANmarAmdeen

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

May23

ANmarAmdeen

Recently by developer

MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

ANmarAmdeen

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

ANmarAmdeen

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

ANmarAmdeen

HTML and URL codes

Always find my self needing to know those quickly to continue working, so ...

2018Sep24

ANmarAmdeen

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9

ANmarAmdeen

FileSize_Formatted

Returns file size in formated human way (mb, gb, etc..) Or, it can format any ...

2018Apr25

ANmarAmdeen