Search results 60

Sorted from new to old.

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

Sun 7AM

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

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

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

Feb5

RangeValues

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

Jan25

ANmaPivotTable_Clear

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

2023Dec22

Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

LastRow_Remove

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

2022Aug16

1 2 3 4