Hello!
I'm looking for some assistance with a solution to a bit of a pickle I'm in regarding Excel. At work we are doing a bit of a competition about who can loose the most weight over summer, and have created an excel document to keep track of this. Now I'm thinking of making finding the winner a bit easier.
Finding out weight loss percentage I'm doing (lostweight/original weight), which results in a result alike: 0.23456 and then converted to percentage.
What I would like to do is the following:
Me and some colleagues have a document where we each have one sheet, named after us.
In our sheets we have a cell, in the same place for everyone sheet: D4, where our final result will show up after entering our weights.
I'm creating a 9th sheet to display the winner in, and I'm wondering is if it's possible to compare the value of cell D4 between all 8 sheets, and then paste the name of the sheet and value into the 9th sheet.
What I'm thinking is something along the lint of adding to A1 on sheet 9 manually: "The winner is:" and then in A2 pasting the name of the winning sheet and in A3 the value of the winning cell.
Is this possible without totally going crazy?
I have uploaded an example files to a page since I couldn't attach here: TinyUpload.com - best file hosting solution, with no limits, totaly free
It should show what I mean a bit better.
If you have any questions or want me to upload someplace else, just shout!
I'm looking for some assistance with a solution to a bit of a pickle I'm in regarding Excel. At work we are doing a bit of a competition about who can loose the most weight over summer, and have created an excel document to keep track of this. Now I'm thinking of making finding the winner a bit easier.
Finding out weight loss percentage I'm doing (lostweight/original weight), which results in a result alike: 0.23456 and then converted to percentage.
What I would like to do is the following:
Me and some colleagues have a document where we each have one sheet, named after us.
In our sheets we have a cell, in the same place for everyone sheet: D4, where our final result will show up after entering our weights.
I'm creating a 9th sheet to display the winner in, and I'm wondering is if it's possible to compare the value of cell D4 between all 8 sheets, and then paste the name of the sheet and value into the 9th sheet.
What I'm thinking is something along the lint of adding to A1 on sheet 9 manually: "The winner is:" and then in A2 pasting the name of the winning sheet and in A3 the value of the winning cell.
Is this possible without totally going crazy?
I have uploaded an example files to a page since I couldn't attach here: TinyUpload.com - best file hosting solution, with no limits, totaly free
It should show what I mean a bit better.
If you have any questions or want me to upload someplace else, just shout!
