Excel workbook filtering

[gibbopool2003]

I have a massive Excel workbook made up of 13 worksheets of mobile phone info, what I want to do is be able to filter all the numbers that have had no data, no calls, no texts for the past 6 months or so...is this possible. Each work sheet is a month of data.

 

[ParamRay]

Can you give some information on the structure of the data? What are the columns? What does the data look like the rows? Etc.

 

[gibbopool2003]

The columns are laid out as Name, Group Code, Phone, Username, Call Vol, Data Vol, Events, Duration. The row will have a 5 Character code in it, location, mobile number, name of the user, how many calls it has made, how many bytes of data used, and number of text messages (Events). I need to filter or show phones that have had, zero call vol, zero data vol and zero events for at least 6months.....all sheets are setup the same and there are 13 months worth of data seperated into month tabs along the bottom labelled May 2019 all the way back to April 2018

 

[justin 00089]

for this I would us CTR+SHIFT+RIGHTARROW+DOWNARROW on the first record of each sheet to highlight all of your data and copy it over to the end of the table on the first sheet. This will consolidate all of your data onto one sheet. After this, simply highlight the header row, insert a filter (sort and filter section of the data tab) and then click the down arrow on the columns of interest. Un-tick all of the values expect for the zero values in each of the desired columns and this should show the records you are interested in. If you click on the 'select all' box first this will un-tick all of the boxes and then you can just tick the zero box.)