Search results 178

Sorted from new to old.

ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

Sat 11AM

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Fri 3AM

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

Thu 5PM

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

Apr12

String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

Apr10

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

Apr6

ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

ANmaSum_5IFs

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

Jan8

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

ANmaSum_4IFs

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

2024Nov13

Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

2024Nov13

ConditionalFormatting_ColorARow

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

2024Nov10

1 2 ...11 12