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

user BossDG said: (!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. 

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