Search results 84

Sorted from new to old.

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

Nearby Color shades

Calculate colors close to input color, a jquery html that will give you 10 ...

2023Nov8

Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

2023Oct17

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

Web.config redirect

Redirect URLs to certain page passing its name. This is web.config from one of ...

2023Aug5

CreditCardType

Returns credit card type and whether it is valid or not. Found it in my old ...

2023Jul28

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

Enable Blocked Macros in O365 from OneDrive

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22

Excel recovered files

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

2023Mar31

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

1 2 ...5 6