Requirement: Filter data in Table using Array in Excel
To Filter data from one table to another, which had a collection of strings to get filtered, as the Name enter in Representative column it display on Table2.
=FILTER(A2:C8,A2:A8=B11)
Here the name entered on Representative column, the changes display on Table2.
