Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug 28, 2013
user Peter Nolan (http://productforums.google.com/forum/?zx=rjvzs6hyvk66#!mydiscussions/docs/-y1Rvopvfbg)
extracting information from tables and creating sorted lists without using the sort feature
I've created a spreadsheet that has a stock portfolio listed along with the various attributes of the stocks in the portfolio i.e.: name, price, cost, fair market value, gain/loss, % of potfolio etc. On a separate worksheet in the same spreadsheet I'm trying to created a list to identify the stocks that represent the highest percentage of my portfolio, the one with the highest gains, the ones with the highest losses etc.. I can get that information but I can`t get the adjoining cells to link so that I know the stock's name. I've found the google sort feature has caused me problem where I've had to re-enter all my information again and doesn't work very well as it messes up my information.