Search results 60

Sorted from new to old.

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

2024Apr29

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

2024Apr8

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

2024Mar14

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24

SearchinHTMLTable

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

2023Nov12

ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

2023Apr4

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

1 2 3 4