Want to Filter Columns Just Like In Excel...Can Numbers Do That?
I'm betting that Numbers can filter the columns for me just like Excel did...or in an even more efficient way, but so far I cannot figure it out.
Here is what I have been using the Filtering in Excel for...which is also what I want to use Numbers for:
I have an Employee Roster of all the drivers working for our company. This roster contains their pertinent information, such as Name, Insurance Expiration, Inspection Renewal Date, License Expiration Date, etc. In excel I was able to filter every row of the spreadsheet. Then when I wanted to see the drivers who would have an expired license in the month of February, I would just click the filter arrow at the top of the column with their license expiration dates, and I could pick a specific date like February 1st. Then Excel would list only those drivers with a February 1st License Expiration. I could then click the filter tab again and choose another date, like February 15th, and it would show me just the drivers with a License renewal of February 15th. Then when I was done checking the license dates, I could chick the filter arrow again and choose 'All' and it would bring back all of my rows of information, regardless of their license renewal date.
SO - how can I do that in Numbers? 🙂
Thank you SO much for your help, my fellow Appletons!
Here is what I have been using the Filtering in Excel for...which is also what I want to use Numbers for:
I have an Employee Roster of all the drivers working for our company. This roster contains their pertinent information, such as Name, Insurance Expiration, Inspection Renewal Date, License Expiration Date, etc. In excel I was able to filter every row of the spreadsheet. Then when I wanted to see the drivers who would have an expired license in the month of February, I would just click the filter arrow at the top of the column with their license expiration dates, and I could pick a specific date like February 1st. Then Excel would list only those drivers with a February 1st License Expiration. I could then click the filter tab again and choose another date, like February 15th, and it would show me just the drivers with a License renewal of February 15th. Then when I was done checking the license dates, I could chick the filter arrow again and choose 'All' and it would bring back all of my rows of information, regardless of their license renewal date.
SO - how can I do that in Numbers? 🙂
Thank you SO much for your help, my fellow Appletons!
13" MacBook, Mac OS X (10.6.2)