Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mirroring observations in Excel table along diagonal
Hello all,
I have created a "unit conversion table" in Excel. At the left (cell A2-A51) I have a column with 50 units (like mg/ l or ng/ml). In the top row (B1-AY1) I have the same 50 units transposed. Let's say that the first unit is mg/ml and the second unit is g/ ml. Cell B2 would then contain the value 1, because the unit is converted to itself. Cell C3: same story. Cell C2 would contain the value 0.001 (from mg/ml to g/ml) and cell B3 would contain the value 1000 (from g/ml to mg/ml). Now, to save a lot of time and to prevent errors, I would like to fill in by hand only the values "above" the upper-left-lower-right diagonal (with the 1s). The cells below the diagonal would be filled according to B3=1/C2 or C7=1/G3. Would there be a quick way to do this in Excel? Any ideas? If you need more info I could send you a sample file. Thanks so much for your help. Arjen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Specifying table in Excel 2002 web queries | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
data transfer from Excel to Access but the new table stru is diff | Excel Discussion (Misc queries) |