Search results 21

Sorted from new to old.

NumberBeforeString_HTML2

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

Mar20

ANmaSum_5IFs

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

Jan8

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

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

Total14Round

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

2023Aug8

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

SumOf_3Filters

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

2021Jan29

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

Nautical/Flight Functions

Functions perform various calculations useful for planning trips. MPH2Kt: ...

2020Oct13

FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

2020Apr20

15 Datestamps

15 pure CSS date stamps to be used or Calendar view of a date, something I ...

2019Jan15

pd

Format a number with total number of digits I used it to format a date as ...

2018Dec29

DB Class

Database Class in Classic ASP An old article I found that helps a lot these ...

2018Dec25

Folder Space used

Get sizes of each folder next to the asp file FolderSpace.asp. Then total of ...

2018Dec9

1 2