ilovetheworld
New Member
- Joined
- Aug 13, 2018
- Messages
- 1
Hello !
Actually, I'm facing problem in sumproduct formulae.
The file contains three sheets.
The sheet Data contains the name of the stocks and the respective
opening and closing prices. The sheet Reponses contains names of the
various players of a Mockstock game and the respective quantities of
shares they purchased for each of the 5 stocks mentioned.
The target is to come up with a formula to calculate the opening
investment, closing investment and net profit/loss which isnt the same as
the traditional formula mentioned in the sheet.
The third sheet "Rank" contains the final net profit of the players you need
to Rank those players in order of their profits and then sort them
Rankwise.
Please answer soon. Its really urgent. I have to submit it by tmrw.
Please refer the link below to access excel file to understand the task. Also, you can edit it and give solution by copying 2nd & 3rd sheet data in subsequent sheet so that original sheet doesn't get affected.
https://files.fm/u/mvgwmxxn?k=6ffba993
Actually, I'm facing problem in sumproduct formulae.
The file contains three sheets.
The sheet Data contains the name of the stocks and the respective
opening and closing prices. The sheet Reponses contains names of the
various players of a Mockstock game and the respective quantities of
shares they purchased for each of the 5 stocks mentioned.
The target is to come up with a formula to calculate the opening
investment, closing investment and net profit/loss which isnt the same as
the traditional formula mentioned in the sheet.
The third sheet "Rank" contains the final net profit of the players you need
to Rank those players in order of their profits and then sort them
Rankwise.
Please answer soon. Its really urgent. I have to submit it by tmrw.
Please refer the link below to access excel file to understand the task. Also, you can edit it and give solution by copying 2nd & 3rd sheet data in subsequent sheet so that original sheet doesn't get affected.
https://files.fm/u/mvgwmxxn?k=6ffba993
