If I have an excel spreadsheet with a long table of items, is there a way for me to "extract" a sub-table with only specific characteristics? For example, imagine I had a table with people's names, birthdates, genders, etc. Is there a way for me to get Excel to auto-generate a new table (maybe in another sheet) that lists only the females, or only the people born before 1970? I don't need all of the details on how to accomplish the task (don't feel compelled to provide a huge Excel lesson), but I can't even figure out where to start. At the moment I'm using conditional formatting to highlight the relevant rows, but as the table grows in length, that becomes more and more cubmersome to manage.
2007-02-01
03:07:02
·
6 answers
·
asked by
Qwyrx
6