Search results 62

Sorted from new to old.

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

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

SumOf_3Filters

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

2021Jan29

CreateList_Matching

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

2020May13

HasDups

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

2019Oct5

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

1 2 3 4