How do I return only the rows of a filtered table into a new list???

mtaylor7

New Member
Joined
Feb 16, 2015
Messages
4
I have been struggling with this problem for a long time and it seems like it should be so simple and easy, it is making me extremely frustrated. Here is what is going on:

I have a list of projects that are in different phases (Planning, Complete, Executing, Cancelled, etc). I have a table that is filtering just the projects that are in the phase "Executing". out of the 300 total projects, only 18 of them are in the Executing phase. I want to now create a list that will dynamically pull from this table ONLY the projects that are listed as executing. the reason? I am making a calendar that highlights cells based on the dates that the projects need to be executed in, and I want to have the calendar be right next to the list of projects, but i have one that is filtered out of cell 8 and one that is filtered out of cell 267 and i cant have the calendar be 300 cells tall... I hope this makes sense at all. I Just want to simply return the filtered results of my table, skipping all of the hidden cells and putting it them into a new place, having it update automatically (like when using =offset). Please Help!!!!
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Smitty

MrExcel MVP
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

Why not use a Pivot Table? You can put Phase in the Filter field and only display the Executed projects.

HTH,
 

mtaylor7

New Member
Joined
Feb 16, 2015
Messages
4
With a lot of tweaking I was able to get that to work out for me. Thank you so much!
 

Watch MrExcel Video

Forum statistics

Threads
1,095,747
Messages
5,446,255
Members
405,392
Latest member
Steveoaktree1977

This Week's Hot Topics

Top