Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I'm interested in creating a distance table by the easiest possible way in Excel 2003. With a list of places going down the sheet, can anyone suggest how I get a formula to copy these cells into other cells going along the top? I assume this could be adapted or directly used to duplicate distances as neccassary. For example Place1 Place2 Place3... Place1 0 6 4 Place2 6 0 2 Place3.... 4 2 0 Any ideas appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Creating a Pivot Table | Charts and Charting in Excel | |||
Creating a cell so data goes into a table | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |