| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Picking data
Hi
Can anyone help me how to pick data from a table. The table is sorted on one column and I want to build a new table with rows wich have a specifc data in one column. It is a result list with name, club, klass and points (result) I want a new list for each klass. The main list looks i.e. like this: Tomas Smith - "club" - HC19 - 567 Linda Calway - "club" - DC19 - 544 Franc Moy - "club" - HC19 - 537 and so on The new list shall have only HC19 Tomas Smith - "club" - HC19 - 567 Franc Moy - "club" - HC19 - 537 The main list will change from competion to competion and I want to have a new "klass list" each time. |
|
#2
|
|||
|
|||
|
try data-filter-autofilter
see help or the following url http://www.contextures.com/xlautofilter01.html of debra Dalgleish Tudor wrote in message ... Hi Can anyone help me how to pick data from a table. The table is sorted on one column and I want to build a new table with rows wich have a specifc data in one column. It is a result list with name, club, klass and points (result) I want a new list for each klass. The main list looks i.e. like this: Tomas Smith - "club" - HC19 - 567 Linda Calway - "club" - DC19 - 544 Franc Moy - "club" - HC19 - 537 and so on The new list shall have only HC19 Tomas Smith - "club" - HC19 - 567 Franc Moy - "club" - HC19 - 537 The main list will change from competion to competion and I want to have a new "klass list" each time. |
|
#3
|
|||
|
|||
|
Tnx. How easy it was.
"R.VENKATARAMAN" skrev: try data-filter-autofilter see help or the following url http://www.contextures.com/xlautofilter01.html of debra Dalgleish Tudor wrote in message ... Hi Can anyone help me how to pick data from a table. The table is sorted on one column and I want to build a new table with rows wich have a specifc data in one column. It is a result list with name, club, klass and points (result) I want a new list for each klass. The main list looks i.e. like this: Tomas Smith - "club" - HC19 - 567 Linda Calway - "club" - DC19 - 544 Franc Moy - "club" - HC19 - 537 and so on The new list shall have only HC19 Tomas Smith - "club" - HC19 - 567 Franc Moy - "club" - HC19 - 537 The main list will change from competion to competion and I want to have a new "klass list" each time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
