Extract rows from table

print the value from the specified string table is not difficult - use INDEX(). But if the table is doing the AutoFilter, the task becomes more complicated.

the Essence of the query is to select from the original table the rows that meet certain criteria (like use of standard Filter). will Make the selection of values from the source table using the array formulas. Unlike Filter (CTRL+SHIFT+L or Data/ Sort & filter/ Filter), selected rows will be placed in a separate table.

To retrieve from the table only odd or even rows can use formulas and AutoFilter

To retrieve from the table only unique rows (rows without repeat) you can use the formula.

To display unique rows, you can use the Advanced filter.

To retrieve from the table only the needed rows, you can use formulas and not just AutoFilter. Show the advantages and disadvantages of both approaches.