Search results 36

Sorted from new to old.

MathInsideText

Return string after applying math to each number found inside the string. ...

May8

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

SSL/TLS certificate add/update

Always found myself struggling when applying security to websites for the past ...

2024Nov7

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

ArCaptcha

Captcha in Arabic, great library, will look forward to apply it in my next ...

2024Feb11

Lazy image loading + placeholder

Setup lazy image loading plus setting placeholder to images. Using

2024Feb10

Gototop + Circular scroll progress

JS icon to show progress of scroll in webpage having button to go back to top. ...

2024Jan28

PivotTable_ShowHideItems

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

2024Jan23

SQL Cross Apply String_Split with XML Path

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

2024Jan20

ChartLabelsNumberFormat

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

2023Dec23

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

1 2 3