Search results 84

  2. Search results
  3. count
Sorted from new to old.
Card image
CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Oct6
Card image
CountNumbers_inString

Returns how many numbers found inside a text

Aug1
Card image
CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

Jun22
Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1
Card image
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29
Card image
UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

Feb18
Card image
Grandchildren files and count

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

Jan11
Card image
PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2
Card image
UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28
Card image
SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-01-02: Adding ability to ...

2023Nov12
Card image
Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2
Card image
BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25
Card image
BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11
Card image
Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7
Card image
End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28
Card image
Excel user name

Get application user name or change it Originally from

2023Jun14
12...56