You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Morning all.. I'm trying to get an excel spreadsheet put together that will be used during training projects. Teams have to bid on prices and that will then give result in how well their product does.. if you offer the lowest price you get all of your requested sales. The other variable for this is that the project can be run with different numbers of teams and the number of potential sales will vary based on this.
I'm trying to sort out the ranking for the teams at the moment using a cell reference heavy table. When I try to calculate off this though, Excel simply sees the formula / cell reference not the result. Is there any excel experts here who may be able to help?
Ta 🙂
Ian
You have the cells formatted as "text".
Change them to "General"
Can *you* see the result of the formula ? If so it's not simply the formatting.
Ta.. in the source cell where I have an ='cell ref' I can see the data..
That's an odd one then. I'm not sure how that can happen, there must be something missing from your description above.
Can you give an example of the formula you're using to do the ranking ?
I have three tables;
Table 1 is the source data, same option for each of the teams, spread over 4 parts of the spreadsheet.
Table 2 has a simple cell reference to get all of the similar information into lines / columns, I have done this using the normal cell reference of =A1. The result of this cell reference will show in the sheet as a standard number; eg 10.00
In table 3 I am trying to rank them in order of price.. based on the fact that we need to know the lowest price in order to award a winner, I am using Office 2013, so have used the Rank formula
=RANK.EQ(X13,$X$13:$AA$13,0)
Unfortunately, what I think is happening is that the Rank formula is looking at the cell references from Table 2 and automatically awarding the cell which is the highest up the spreadsheet the position of number 1 (even though numerically, that is wrong for my test data)
🙁
Screen print and post