View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Paul Paul is offline
external usenet poster
 
Posts: 661
Default Sorting columns while keeping row data intact



A B C D E
1 $0.01 1200 $12.00 0.0002
2 0.03 120000 $3,600.00 0.8889
3 0.45 100 $45.00 0.0006
4 1 44000 $44,000.00 0.6001
5 4.5 900 $4,050.00 0.0552
6 0.9 350 $315.00 0.0043
7 0.3 70000 $21,000.00 0.2864
8 1.5 200 $300.00 0.0041


$73,322.00
When i sort a column the row data does not follow.I have tried grouping but
does not seem to work.What am I doing wrong?

E=d/$73,322.00

Thanks in advance

Paul