Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auotomating "Sort" in Excel
Hi everyoe,
Say I have data table like this # Resp Depl AgVr Leth Surv Sust InOp 1 0.609 0.340 0.619 0.692 0.499 0.541 0.164 2 0.856 0.544 0.619 0.677 0.501 0.481 0.851 3 0.799 0.560 0.594 0.523 0.515 0.556 1.000 4 0.591 0.507 0.549 0.585 0.511 0.496 0.851 5 0.815 0.619 0.553 0.543 0.544 0.525 0.851 6 0.622 0.507 0.594 0.452 0.545 0.648 0.851 7 0.653 0.754 0.669 0.552 0.578 0.503 0.851 Before I plot each, I sort them. To do so, say wants to plot #1, I puts them in x-y columns like this: A B Resp 0.609 Depl 0.340 AgVr 0.619 Leth 0.692 Surv 0.499 Sust 0.541 InOp 0.164 SoSI 0.333 RD_Cost 0.868 Pr_Cost 0.970 OS_Cost 0.941 Volume 0.622 Power 0.651 Thermal 0.648 Weight 0.824 Next, I sort them like this: A B Pr_Cost 0.970 OS_Cost 0.941 RD_Cost 0.868 Weight 0.824 Leth 0.692 Power 0.651 Thermal 0.648 Volume 0.622 AgVr 0.619 Resp 0.609 Sust 0.541 Surv 0.499 Depl 0.340 SoSI 0.333 InOp 0.164 Then plot them. How can auotmate this in excel to plot solution-to-plot by "#"? Thanks, Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auotomating "Sort" in Excel
Have you tried recording a macro, and assigning it to a forms button?
-- HTH RP (remove nothere from the email address if mailing direct) wrote in message oups.com... Hi everyoe, Say I have data table like this # Resp Depl AgVr Leth Surv Sust InOp 1 0.609 0.340 0.619 0.692 0.499 0.541 0.164 2 0.856 0.544 0.619 0.677 0.501 0.481 0.851 3 0.799 0.560 0.594 0.523 0.515 0.556 1.000 4 0.591 0.507 0.549 0.585 0.511 0.496 0.851 5 0.815 0.619 0.553 0.543 0.544 0.525 0.851 6 0.622 0.507 0.594 0.452 0.545 0.648 0.851 7 0.653 0.754 0.669 0.552 0.578 0.503 0.851 Before I plot each, I sort them. To do so, say wants to plot #1, I puts them in x-y columns like this: A B Resp 0.609 Depl 0.340 AgVr 0.619 Leth 0.692 Surv 0.499 Sust 0.541 InOp 0.164 SoSI 0.333 RD_Cost 0.868 Pr_Cost 0.970 OS_Cost 0.941 Volume 0.622 Power 0.651 Thermal 0.648 Weight 0.824 Next, I sort them like this: A B Pr_Cost 0.970 OS_Cost 0.941 RD_Cost 0.868 Weight 0.824 Leth 0.692 Power 0.651 Thermal 0.648 Volume 0.622 AgVr 0.619 Resp 0.609 Sust 0.541 Surv 0.499 Depl 0.340 SoSI 0.333 InOp 0.164 Then plot them. How can auotmate this in excel to plot solution-to-plot by "#"? Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort 2 column in the same time "" as dictionary "" | Excel Worksheet Functions | |||
Missing sort ascending or descending when go into "data" "sort"? | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
pictures to work with "data" "sort" option | Excel Discussion (Misc queries) |