Search results 60

Sorted from new to old.

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

HTMLTagAttributeValue

Reads value of certain tag attribute from certain attribute Identify attribute ...

2021May30

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

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

ImagesIn_User

Gets images in a folder where filenames start with "User" Similar to function ...

2019Dec31

HasDups

Indicates if an array contains duplicate values. returns True if more than one ...

2019Oct5

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...

2019Jun28

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1

ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

2018Oct1

TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

1 2 3 4