Search results 35

Sorted from new to old.

ANmaSum_4IFs

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

Nov13

ConditionalFormatting_ColorARow

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

Nov10

SSL/TLS certificate add/update

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

Nov7

SettingSave + SettingRead for NumberFormat

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

Apr19

ANStrSort3

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

Feb20

ArCaptcha

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

Feb11

Lazy image loading + placeholder

Setup lazy image loading plus setting placeholder to images. Using

Feb10

Gototop + Circular scroll progress

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

Jan28

PivotTable_ShowHideItems

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

Jan23

SQL Cross Apply String_Split with XML Path

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

Jan20

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

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

1 2 3