Search results 20

Sorted from new to old.

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

Sep23

MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

May27

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

ANmaFilter3

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

2023Oct13

ANmaHTMLImgDownload

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

2023Aug2

Progress in two nested loops

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

2023Mar7

OutlookFolder_DuplicatesRemove

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

2023Jan1

AddDatabar_ConditionalFormatting

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

2022Aug22

COUNTIFS as Rank

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

2022Jan1

Highlight row of current month

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

2021Sep2

SumOf_3Filters

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

2021Jan29

ImagesIn_User

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

2019Dec31

MinIF and MaxIF in Excel 2010

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

2019Feb1

User-Defined Formatting

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

2019Jan9

IsEven + IsOdd

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

2018Sep27

ConfigWeb_Read

Reads a key value from certain section in Web.config Originally from ...

2018Sep5

1 2