ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

ANmaHTMLImgDownload

Downloads image from src of < img html tag after searching for list of ...

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

OutlookFolder_DuplicatesRemove

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

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

SumOf_3Filters

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

ImagesIn_User

Gets images in a folder where filenames start with "User" Similar to function ...

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

MaxIF_MinIF_byNMR.zip

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

IsEven + IsOdd

Returns True if integer is even by using IsEven While IsOdd, will returns True ...