Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My experience with Excel is very limited. I want to be able to use an Excel
spreadsheet to make various selections. For instance column B is used as the selection cell, equations are in column C. If I put the selection number in column B, I want the selected equation to be put in a different column. For example Cells A1 to A40 are numbered 1 to 40. Cells C1 to C40 each contain an equation. I want to use Cells B1 to B40 to type in the selection number. For instance, I want to select the equations in C5, C11, C20, C33 and C38. So for my selections I type number 1 in B5 number 2 in B11 number 3 in B20 number 4 in B33 number 5 in B38 The equations in C5, C11, C20, C33 and C38 are put in the selected order into a column M1, M2, M3, M4, M5 and M6 on the same or another worksheet. For example: A B C 1 1 A+B+C 2 2 2A+2B+2D 3 3 4y+4x+3w+4y+4x 4 4 4y+4x+3w+4y 5 5 1 y+4x+7w 6 6 4y+10x+3w 7 7 4y+3x+3w 8 8 11y+4x+3w 9 9 9y+4x+3w 10 10 4y+4x+14w 11 11 2 y+7x+3w Any help gratefully accepted. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To find equation for two sets of non contiguous data | Charts and Charting in Excel | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Need Help with #N/A in equation | Excel Discussion (Misc queries) | |||
Averaging/Rounding Equation Problem | Excel Worksheet Functions | |||
Averaging/Rounding Equation problem | Excel Discussion (Misc queries) |