Search results 60

Sorted from new to old.

ConditionalFormatting_Clear

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

2024Nov10

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

Sheet_RowID_Generate + _LastUsed

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

2024Nov3

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

2024Sep5

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

2024Jul13

HTMLTagID_Previous

Return id for any html tag that was found above certain location of html page. ...

2024Feb2

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

2024Jan12

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

ReNumber_IDColumn_inTable

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

2023Dec17

Luhn

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

2023Jul25

Excel user name

Get application user name or change it Originally from

2023Jun14

ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

2023Apr4

Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

2023Feb19

1 2 3 4