Points Ranking Formulas

Easier to start all over, Jim g. Now that I see your detailed set-up,
here's the formulas you need to compute the points. I've implemented these
in your file and will send it back to you.

Placed in F7:
=IF(OR(E7="",E$4=""),"",INDEX(Sheet2!$B:$B,MATCH(E 7,Sheet2!$A:$A,0))
+E$4*5*INDEX(Sheet2!$C:$C,MATCH(E7,Sheet2!$A:$A,0) ))

Copied F7, then with CTRL key held down,
selected cells H7,J7,L7,N7,P7,R7,T7,V7,X7
Then right-click paste special formulas OK

This pastes the same formula adjusted relatively where required into all the
required cells. Then just copy the formulae down the respective columns.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Thanks Max,

I think I'm starting to get it now. It takes awhile to understand how the
formulas work.

You did a great job on this!

Cabo Wabo Jim

"Max" wrote:

Easier to start all over, Jim g. Now that I see your detailed set-up,
here's the formulas you need to compute the points. I've implemented these
in your file and will send it back to you.

Placed in F7:
=IF(OR(E7="",E$4=""),"",INDEX(Sheet2!$B:$B,MATCH(E 7,Sheet2!$A:$A,0))
+E$4*5*INDEX(Sheet2!$C:$C,MATCH(E7,Sheet2!$A:$A,0) ))

Copied F7, then with CTRL key held down,
selected cells H7,J7,L7,N7,P7,R7,T7,V7,X7
Then right-click paste special formulas OK

This pastes the same formula adjusted relatively where required into all the
required cells. Then just copy the formulae down the respective columns.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

You're welcome, Jim !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Cabo Wabo Jim" wrote in message
news
Thanks Max,

I think I'm starting to get it now. It takes awhile to understand how the
formulas work.

You did a great job on this!

Cabo Wabo Jim