Search results 47

Sorted from new to old.

MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

May7

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

Apr10

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

Mar10

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

Feb26

ANmaRemoveDuplicates2

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

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

ConditionalFormatting_Clear

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

2024Nov10

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

2024Nov1

JSon functions to add, read and delete entry

3 Json functions to read full node by an image, add full node to file or delete ...

2024Oct29

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

2024Aug7

ExtractNumeric_FromCell

Returns the number from an HTML cell after cleaning and finding sign. We faced ...

2024Aug6

ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

2024Feb4

HTML_CleanNumber

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

2024Jan31

1 2 3