G+_Martin Roitman Posted February 19, 2014 Share Posted February 19, 2014 Hi KW community, I have an Excel question related to dashboards. I need to show data from a big table in to small table when the "state" (NY) change. So I have the data tab with all the data and I just want to show one state at the time with all the information. Is there any way to do it without having a giant IF statement?? Thanks!!! Link to comment Share on other sites More sharing options...
G+_Dave Hart Posted February 20, 2014 Share Posted February 20, 2014 Depending on what you are trying to show, I would look at using a filter (very simple) or a pivot table. Link to comment Share on other sites More sharing options...
Recommended Posts