Search results 60

Sorted from new to old.

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

Mar23

Concatenate_HTMLColumn

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

Mar14

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Mar2

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Jan31

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

SearchinHTMLTable

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

2023Nov12

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3

Range2Block

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

2023Mar6

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

LastRow_Remove

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

2022Aug16

Export2CSV

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

2022May16

1 2 3 4