| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link data in rows to columns to create table
I want to display a league table showing first 5 names and their positions in
asscending order. There will be ties some weeks eg 1,1,3,4,5 and position 5 will sometimes be tied so I have left space for 9 possible "winners". The names will go in H8:H16 and their positions in G8:G16, sorted by position order. The names are static in B1:AI1, and their positions vary week to week in B5:AI5. eg This week name in G1 is 1st and last week the name in AB1 won. Anyone out there done this before or have a working solution? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I rotate data in Excel table (rows to columns, and vv)? | Excel Discussion (Misc queries) | |||
| Using data in rows in a table in columns. | New Users to Excel | |||
| How do I create a link between columns from a data chart? | Excel Discussion (Misc queries) | |||
| Change data to appear in rows instead of columns (reverse a table. | Excel Discussion (Misc queries) | |||
| How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
Threaded Mode
