3. Exclude and Match Option

3. Exclude and Match Option

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

The Plot: [1] The non-numeric x-y data pair to be excluded. [2] To augment the Exclude’s? array with the Match? value.

Using Exclude’s? array alone would exclude all the last five x-y data pairs. The Match? value serves to refine the exclusion, only if a case-sensitive match is found between the Match value and the flag’s values(s) will the corresponding x-y data pair be excluded. This is confirmed by the post-computation ‘For Your Information . . .’ dialog:

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 is one flag populated with two values, b and c.

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

To get more from ‘For Your Information . . .’ see Information Messages in the user guide.

Note: Function STD.AUCINF.LT returns the area under the curve to infinity by linear trapezoidal approximation.


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