create small tables from a large table

**ruleworld** · 08-01-2010, 03:16 AM

Hi,

I have a large table of 1000 peoples name, age, height and weight. what i want to do is to create 3 small tables that will show the top 10 most old, most tall and most heavy people. the table of oldest people should also show their height and weight and so on. how is it possible to do in excel 2007? thanks.

**royUK** · 08-01-2010, 03:21 AM

You can use AutoFilter & a Custom Filter for Top 10

**ruleworld** · 08-01-2010, 04:03 AM

Originally Posted by royUK

You can use AutoFilter & a Custom Filter for Top 10

so does that mean i have to copy the table 3 times for each attributes? it should not be like this as the file will become large.

**ruleworld** · 08-01-2010, 04:26 AM

i have tried copying the table and apply filters separately. but its not working. when i apply filter to a table the filter from the other table goes away and all the table becomes visible. it seems only one filter works in a worksheet.

**royUK** · 08-01-2010, 04:43 AM

Using AutoFilter means the data can all remain in one table & you use the filtered data to view. This is much more efficient than creating individual tables.