I have 2 sheets, one with a list of firms, the other with those firms and their historical earnings.
On Sheet1 I have company names in column A
On Sheet 2 I have company names going across row 1, in column A i have dates and then each of the companies earnings are in their column.
My goal is to have Sheet1 have the standard deviation of the earnings in column B for each of the companies. For example, if on Sheet1 I have IBM in cell A1, I want a formula to look at Sheet2, find IBM in row1, and then calculate the standard deviation of the data in IBMs column.
Please let me know if any of this is not clear or if you want me to attach the spreadsheet. Thanks for the help!
Bookmarks