Search results 26

Sorted from new to old.

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

Feb26

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

Jan8

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2

ANmAddressRefStyle

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

2024Sep23

MatchIf5Up

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

2024May27

MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6

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

1 2