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/
---------------------------------------------------------------
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
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/
---------------------------------------------------------------
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
No comments:
Post a Comment