Forum Discussion
Listing select data from one tab in another
I am trying to find a formula to list select data from one tab into tab sheet on the same document. For example, say Tab 1 had the following information listed in Column A: Apples A Oranges A ...
I you are using a modern version of Excel, you can use the FILTER function.
=FILTER('Tab1'!A1:A4,ISNUMBER(FIND("Apples",'Tab1'!A1:A4)))