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 in Computers & Internet ➔ Software
autofilters - thats what you want to use. Then filter column data by the criteria you want from the drop-down. Copy and paste to another sheet.
2007-02-01 03:15:04 · answer #1 · answered by Greg 2 · 0⤊ 0⤋
The easiest way is to sort the table by the value you're interested in extracting. (Use the menu > Data > Sort). That will move all similar items together, which you can then select as a unit and copy to a new sheet.
2007-02-01 03:16:59 · answer #2 · answered by Keith P 7 · 0⤊ 0⤋
You can do it in Visual Basic for Applications (VBA). However, that takes a lot of effort to learn. VBA is accessed through Tools/Macros/Visual Basic, and there is some help there. But you shoudl probably buy a book on VBA first. Many computer stores sell books on VBA. Also the internet.
2007-02-01 03:19:12 · answer #3 · answered by Always Hopeful 6 · 0⤊ 0⤋
Try using something called a pivot table. Basically you have an entire pool of data and a pivot table allows you to select which pieces of data you actually need.
2007-02-01 03:15:13 · answer #4 · answered by Anonymous · 0⤊ 0⤋
No usual expressions yet you do have some concepts. Say your parameter is n. i can make some "intermediate" columns that contain the region of n= (check out the discover or search for function), then use LEFT proper or MID to extract the products you opt on (case in element, get each thing to the right of n=, then search for & and get each thing to the left of the & contained in the recent string). look contained in the help less than string applications for better information.
2016-12-03 07:52:29 · answer #5 · answered by haltom 4 · 0⤊ 0⤋
you have the import the data from exel to spratesheet
2007-02-01 03:11:17 · answer #6 · answered by hrs_1349_1971 2 · 0⤊ 0⤋