5. Include and Match Option

5. Include and Match Option

The x-y data is modified from the classic by Milo Gibaldi and Donald Perrier:

The Plot: [1] Not to include (select) the non-numeric x-y data pair. [2] To augment the Include’s array with Match? value.

Using Include’s array alone would generate an alert message (and the computation aborts):

The Match? value serves to refine the inclusion. Only if a case-sensitive match is found between the Match value and flag’s values(s) will the corresponding x-y data pair be included. Note that there is no post-computation ‘For Your Information . . .’ message for the included x-y data pairs.

Note that the flag value(s) can be a number or text. A text value can have multiple characters. And a number is treated as text. In this example, there are two flags populated with more than one values.

In this example the Match? value references a cell value. The Match value can also be directly entered into the Match? value argument.

To find out more about alert messages see Alert Messages in user guide.

Note: Function STD.LAMDA.INCL returns the first-order decline rate constant of the curve.

For Your Information: The Include and Match equipped functions also have the Exclude and Match version. For STD.LAMDA.INCL it is STD.LAMDA.


M. Gibaldi and D. Perrier. Pharmacokinetics, Second Edition, Revised and Expanded. New York and Basel: Marcel Dekker, Inc. Page 448 (1982).