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
- Oranges B
- Apples B
I want Tab 2 to automatically find all instances where Apples appear in the list and then list them like this:
- Apples A
- Apples B
At the moment, all I can do is a formula to only show where Apples are listed, but the formula leaves lots of blank spaces in between the listings, so it looks like this:
- Apples A
- Apples B
Is there any way I can just get specific data from one tab to be listed in another tab with no gaps in rows?
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)))
