Sorting and Sum

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

There is an Excel Spreadsheet like the following

Project Value Sum
Power 120 354 (Power + Computer)
Computer 234
AV 123
Quest 200

There is a requirement that we have to sort Project in
ascending order but keep the sum unchanged (as follow)

Project Value Sum
AV 123 354
Computer 234
Power 120
Quest 200

I have tried a number of ways but still cannot get it
fixed. Is there any suggestion ?

Thanks
 
You've got one guess at your other post.
There is an Excel Spreadsheet like the following

Project Value Sum
Power 120 354 (Power + Computer)
Computer 234
AV 123
Quest 200

There is a requirement that we have to sort Project in
ascending order but keep the sum unchanged (as follow)

Project Value Sum
AV 123 354
Computer 234
Power 120
Quest 200

I have tried a number of ways but still cannot get it
fixed. Is there any suggestion ?

Thanks
Click to expand...
 
Back
Top