May 14, 2020
Hey All -
Thank you in advance for any support.
I have a Microsoft Form that collected data from a number of users and that data automatically populates a table in Excel (see form-generated data); I want to provide leadership with a separate sheet that pulls rows from that table into a separate sheet based on the value of the item selected in the drop-down list (see B2 in drop-down list table). The idea is that if I changed the value in B2 to another item in that list, the formulas would organize the information below to only reflect info from the parent sheet that correlates to that Branch name (in this example it is WD - Wetlands, and if the value was WD - Clean Water you would see the Chesapeake Bay row from the parent data sheet).
I tried some index, match, countif formula combos and some row,column additions but I am struggling to make it happen.
December 7, 2016
See attached file. The easiest thing to do is to either insert a slicer to your table, see Full Data Input sheet for an example, or to use a Pivot Table where you either use the filter drop down list, or a slicer. See Deadline Tracker sheet for examples. The last example I am not showing the Pivot Table column headers, as I instead wanted to use the fixed headers you use.
In my opinion you should avoid creating a formula based list, as it requires administration the day you need to extend the rows or columns.