Search results 60

Sorted from new to old.

ANmaRemoveDuplicates2

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

Dec4

ANmaRemoveDuplicates4

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

Dec4

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

Nov17

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 ...

Oct29

CleanArray_2Dim

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

Oct24

CountColumnCells_Unique

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

Oct6

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

Sep3

HTMLTable_FullRow_NonBlanks

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

Aug7

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Jul24

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

Jul18

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Jul13

ANmaRemoveNestedTags

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

Feb4

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

Remove Managed by Your Organization from Edge

AI helped me here to remove the message on my browser of (Managed by your ...

Jan10

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

1 2 3 4