Steviefiege
Board Regular
- Joined
- Aug 29, 2018
- Messages
- 66
Hi, i'm hoping this is an easy one, i just can't get my head around the formula to use.
Below is my spreadsheet with all my players on the left & every position they play in & their ratings.
On the right is every individual player & their BEST rating. What i'm wanting is for on the right under BEST POSITION is to match the player & the rating to get their BEST POSITION.
For example: Aaron Taylor-Sinclair his best rating is 59.29%, under BEST POSITION i want it to say CWB (Left) as thats his best position but i cant get the formula right. I've put it in bold on the left as so you can see which one i mean.
<tbody>
[TD="class: xl63"]PLAYER[/TD]
[TD="class: xl63, width: 100"]POSITION[/TD]
[TD="class: xl63, width: 100"]RATING[/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 130"]PLAYER[/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 100"]RATING[/TD]
[TD="class: xl63, width: 64"]BEST POSITION[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]Frazer Richardson[/TD]
[TD="class: xl66"]CWB (Right)[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Aaron Taylor-Sinclair[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl74"]59.29%[/TD]
[TD="class: xl75"][/TD]
[TD="class: xl67"]Gary Taylor-Fletcher[/TD]
[TD="class: xl68"]AVP[/TD]
[TD="class: xl64"]66.67%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Andrew Williams[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Paul Keegan[/TD]
[TD="class: xl66"]AVP[/TD]
[TD="class: xl64"]65.00%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Andy Butler[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl67"]Gary Taylor-Fletcher[/TD]
[TD="class: xl68"]DLP[/TD]
[TD="class: xl64"]63.89%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Benjamin Greasley[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Mathieu Baudry[/TD]
[TD="class: xl70"]BPD[/TD]
[TD="class: xl64"]62.35%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Cedric Evina[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Paul Keegan[/TD]
[TD="class: xl66"]DLP[/TD]
[TD="class: xl64"]62.22%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Conner Williamson[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Tommy Rowe[/TD]
[TD="class: xl66"]CWB (Left)[/TD]
[TD="class: xl64"]61.67%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Craig Alcock[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Tommy Rowe[/TD]
[TD="class: xl66"]AVP[/TD]
[TD="class: xl64"]61.11%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Dany N'Guessan[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Andy Butler[/TD]
[TD="class: xl70"]BPD[/TD]
[TD="class: xl64"]60.88%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl72"]David Foley[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Andrew Williams[/TD]
[TD="class: xl68"]Winger (Right)[/TD]
[TD="class: xl64"]60.45%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Dean Winnard[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl67"]Gary Taylor-Fletcher[/TD]
[TD="class: xl68"]CF[/TD]
[TD="class: xl64"]60.23%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Frazer Richardson[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Craig Alcock[/TD]
[TD="class: xl70"]BPD[/TD]
[TD="class: xl64"]60.00%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Gary McSheffrey[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"] Aaron Taylor-Sinclair
[/TD]
[TD="class: xl66"] CWB (Left) [/TD]
[TD="class: xl64"] 59.29% [/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl72"]Gary Taylor-Fletcher[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Tommy Rowe[/TD]
[TD="class: xl68"]IF (Left)[/TD]
[TD="class: xl64"]59.29%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Harry Middleton[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]Aaron Taylor-Sinclair[/TD]
[TD="class: xl70"]BPD[/TD]
[TD="class: xl64"]59.12%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Jai Quitongo[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Tommy Rowe[/TD]
[TD="class: xl66"]DLP[/TD]
[TD="class: xl64"]58.33%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Joe Pugh[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl67"]Gary Taylor-Fletcher[/TD]
[TD="class: xl68"]Winger (Right)[/TD]
[TD="class: xl64"]58.18%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Joe Wright[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Cedric Evina[/TD]
[TD="class: xl66"]CWB (Left)[/TD]
[TD="class: xl64"]58.10%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]John Marquis[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Andrew Williams[/TD]
[TD="class: xl68"]IF (Left)[/TD]
[TD="class: xl64"]56.79%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Jordan Houghton[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Jordan Houghton[/TD]
[TD="class: xl66"]DLP[/TD]
[TD="class: xl64"]56.67%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Jordan Linley[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl67"]David Foley[/TD]
[TD="class: xl68"]Winger (Right)[/TD]
[TD="class: xl64"]56.36%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Joseph McCormick[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
</tbody>
Kind Regards
Steve
Below is my spreadsheet with all my players on the left & every position they play in & their ratings.
On the right is every individual player & their BEST rating. What i'm wanting is for on the right under BEST POSITION is to match the player & the rating to get their BEST POSITION.
For example: Aaron Taylor-Sinclair his best rating is 59.29%, under BEST POSITION i want it to say CWB (Left) as thats his best position but i cant get the formula right. I've put it in bold on the left as so you can see which one i mean.
<tbody>
[TD="class: xl63"]PLAYER[/TD]
[TD="class: xl63, width: 100"]POSITION[/TD]
[TD="class: xl63, width: 100"]RATING[/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 130"]PLAYER[/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 100"]RATING[/TD]
[TD="class: xl63, width: 64"]BEST POSITION[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]Frazer Richardson[/TD]
[TD="class: xl66"]CWB (Right)[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Aaron Taylor-Sinclair[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl74"]59.29%[/TD]
[TD="class: xl75"][/TD]
[TD="class: xl67"]Gary Taylor-Fletcher[/TD]
[TD="class: xl68"]AVP[/TD]
[TD="class: xl64"]66.67%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Andrew Williams[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Paul Keegan[/TD]
[TD="class: xl66"]AVP[/TD]
[TD="class: xl64"]65.00%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Andy Butler[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl67"]Gary Taylor-Fletcher[/TD]
[TD="class: xl68"]DLP[/TD]
[TD="class: xl64"]63.89%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Benjamin Greasley[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Mathieu Baudry[/TD]
[TD="class: xl70"]BPD[/TD]
[TD="class: xl64"]62.35%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Cedric Evina[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Paul Keegan[/TD]
[TD="class: xl66"]DLP[/TD]
[TD="class: xl64"]62.22%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Conner Williamson[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Tommy Rowe[/TD]
[TD="class: xl66"]CWB (Left)[/TD]
[TD="class: xl64"]61.67%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Craig Alcock[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Tommy Rowe[/TD]
[TD="class: xl66"]AVP[/TD]
[TD="class: xl64"]61.11%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Dany N'Guessan[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Andy Butler[/TD]
[TD="class: xl70"]BPD[/TD]
[TD="class: xl64"]60.88%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl72"]David Foley[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Andrew Williams[/TD]
[TD="class: xl68"]Winger (Right)[/TD]
[TD="class: xl64"]60.45%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Dean Winnard[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl67"]Gary Taylor-Fletcher[/TD]
[TD="class: xl68"]CF[/TD]
[TD="class: xl64"]60.23%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Frazer Richardson[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Craig Alcock[/TD]
[TD="class: xl70"]BPD[/TD]
[TD="class: xl64"]60.00%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Gary McSheffrey[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"] Aaron Taylor-Sinclair
[/TD]
[TD="class: xl66"] CWB (Left) [/TD]
[TD="class: xl64"] 59.29% [/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl72"]Gary Taylor-Fletcher[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Tommy Rowe[/TD]
[TD="class: xl68"]IF (Left)[/TD]
[TD="class: xl64"]59.29%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Harry Middleton[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl65"]Aaron Taylor-Sinclair[/TD]
[TD="class: xl70"]BPD[/TD]
[TD="class: xl64"]59.12%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Jai Quitongo[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Tommy Rowe[/TD]
[TD="class: xl66"]DLP[/TD]
[TD="class: xl64"]58.33%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Joe Pugh[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl67"]Gary Taylor-Fletcher[/TD]
[TD="class: xl68"]Winger (Right)[/TD]
[TD="class: xl64"]58.18%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Joe Wright[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Cedric Evina[/TD]
[TD="class: xl66"]CWB (Left)[/TD]
[TD="class: xl64"]58.10%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]John Marquis[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Andrew Williams[/TD]
[TD="class: xl68"]IF (Left)[/TD]
[TD="class: xl64"]56.79%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl71"]Jordan Houghton[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl69"]Jordan Houghton[/TD]
[TD="class: xl66"]DLP[/TD]
[TD="class: xl64"]56.67%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Jordan Linley[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl67"]David Foley[/TD]
[TD="class: xl68"]Winger (Right)[/TD]
[TD="class: xl64"]56.36%[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl73"]Joseph McCormick[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
</tbody>
Kind Regards
Steve