STACK.FIND

This function uses the criteria range to select and copy one or multiple rows from the StackRange to the TargetRange. Optionally it deletes all found records after the extract operation (remaining rows all move up!)

Syntax

=STACK.FIND(StackRange, CriteriaRange, [TargetRange], [Drop], [Unique])

Arguments

Name	Type	Description
StackRange	Range	Range, where the source range items are added to. The first row of the StackRange is a title range and remains unchanged.
CriteriaRange	Range	The CriteriaRange has at least 2 rows, the first one is the labels row with labels also found in StackRange (not necessarily all and maybe not in the same order!), the second to nth row contain filter settings. Note: criteria values can start with a comparison-operator like, >, >=, <, <=, = or <> Settings in the same row are combined using AND, multiple rows are OR.
TargetRange (optional)	Range	If specified, TargetRange must have two rows minimum, the first row has labels also found in StackRange (not necessarily all and maybe not in the same order!). The result of the filter is copied to the matching columns in the TargetRange. Note: TargetRange can have more than 2 rows. If it has more than 2 rows the additional rows can take the additional hits of the filter extract.
Drop (optional)	Boolean	If set to TRUE it drops the selected rows from the stack. Default value: FALSE
Unique (optional)	Boolean	If set to TRUE it drops or copies equal rows only once. Two rows are equal if they have same value in each column. Default value: FALSE

Return

Type	Description
Boolean or Error	TRUE, if at least one matching value was found, otherwise FALSE. In case of an error the corresponding error value is returned.

Examples

	A	B	C	D
1	Name	Age	City	Street
2	Maier	43	Sidney	Main Street
3
4	Name	Age	City	Street
5	Maier	43	Sidney	Main Street
6	Miller	53	Sidney	South Street
7	Jones	45	Sidney	West Street
8	Maier	35	Sidney	High Street
9
10	Name	Age

Formula	Result	Comment
=STACK.FIND(A4:D8,A1:D2,A10:B12)	After calling STACK.FIND