Search results 67

Sorted from new to old.

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

2024Jan17

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

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

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

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

1 2 3 4 5