Search results 60

Sorted from new to old.

MatchIfUp_DateTime

Finds first cell in column that is a date/time from bottom to top (technically ...

Aug4

Formulas_FromFile_ToRow

Imports formulas from file into list of cells defined in file itself into ...

2025Oct11

Formulas_FromRow_toFile

Exports all formulas in a row of sheet into text file.

2025Oct10

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

2025May27

MatchIf8Up

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

2025May7

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

2025May3

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

2025May2

ANmaRow_Duplicate1

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

2025Apr17

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

2025Feb19

ANmaSum_5IFs

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

2025Jan8

ANmaRemoveDuplicates2

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

2024Dec4

Match6_Until

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

2024Nov28

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

2024Aug7

HTMLRow_Cell

Returns column with ColumnID ... the full area between < td ...> and < /td> ...

2024Aug4

HTMLTable_FullRow

Returns full row from RowID ... the full area between < tr ...> and < /tr> from ...

2024Aug4

1 2 3 4