Monday, August 13, 2012

yogi_Extract Sort And Sum Specified Parts In Different Sheets From Table in Main

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #690   Aug 13, 2012     www.energyefficientbuild.com.

user BossDG said: (http://productforums.google.com/forum/?zx=76albpq7qu02#!category-topic/docs/spreadsheets/HH760727X4g%5B1-25%5D)
Sort outcome of a function
Below you will find a link to a spreadsheet i have a problem with.
I have a main sheet in wich u find 5 different part numbers. Now i want a new sheet "sort" and make an = reference to sheet "main". This all goes ok but here is the problem, when i sort from a to z, it sorts the original data and not the outcome of the = function.
What i want to do in the sheet "sort" is the following:
sort them from a to z 
remove the double items
sum up the stock of the double items.
I've also made a sheet with "Result i want". 
All this worked in excel but does not seem to work in docs. So if anyone can plz give me some tips on howto get to my end result.
https://docs.google.com/spreadsheet/ccc?key=0ApAJo77bskcIdE9CYkN3dDRtTHAwOW1TNHRjcHdhR3c 

---------------------------------------------------------------
following is a solution to a bit more generalized problem in that I have considered ...
1) all parts
2) Parts that BeginWith
3) Parts that do not BeginWith