Search results 466

Sorted from new to old.

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

2024May31

MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

SortArea4

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

2024Apr15

Between2int and Between2intinc

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

2024Mar23

OneDrive Reset

Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...

2024Mar5

Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

2024Mar5

FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

2024Mar4

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

2024Mar3

NumberNumberNumber

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

2024Mar2

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

2024Feb25

CutString11

Cuts long string from certain character to certain character with option to ...

2024Feb24

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

Free online tools - convertcase.net

Bunch of online some text and image tools, helpful for most online users these ...

2024Feb15

1 2 ...5 ...29 30