Note: In order to use the spreadsheet examples, you need to download Business Functions
|SelCats (Values, Categories, [ChosenCategories], [Options], [CatMin], [CatMax])|
|Select values and create a range based on categories|
Values for "Options" (or "Opts")
0 or missing: Categories and ChosenCategories are not necessaily in order
You do not have to specify a value for the minimum or maximum category numbers. There are two category selection methods here: one being the chosen categories and the other being the minimum and maximum category numbers. If a category meeets either of these two criteria, it is selected.