Search results 59

Sorted from new to old.

ANmaRemoveDuplicates2

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

Dec4

ConditionalFormatting_Clear

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

Nov10

HTMLTable_Cell

Returns content of cell by location ... RowID and ColumnID HTMLTable expected ...

Aug5

HTMLRow_Cell

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

Aug4

HTMLTable_FullRow

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

Aug4

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

May16

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Jan20

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

ANmaFilter3

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

2023Oct13

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

1 2 3 4