Search results 32

Sorted from new to old.

NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

Mar20

TrimLines

Remove all line breaks from text from a text. Not like

Jan31

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

Jan8

YoutubeLinks2YoutubeEmbeds

Convert all links in text block into youtube embeds to show inside a website. ...

2024Dec22

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

ANmaSum_4IFs

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

2024Nov13

SSL/TLS certificate add/update

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

2024Nov7

RangeValues

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

2024Jan25

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

2023Jul30

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

2021May29

Open Window

Open another window with java script (_blank) Setting up width, height, ...

2021Mar22

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

1 2