Search results 59

Sorted from new to old.

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

Jan12

ANmaRemoveDuplicates2

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

2024Dec4

ConditionalFormatting_Clear

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

2024Nov10

HTMLTable_Cell

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

2024Aug5

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

JSON_To_Table

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

2024Jun6

ANmaHTMLTables_Combine2

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

2024May16

SortArea4

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

2024Apr15

SQL Cross Apply String_Split with XML Path

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

2024Jan20

ChartLabelsNumberFormat

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

2023Dec23

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