Need help on a VBA project...PLEASE!!!
Posted by Knight Coach on January 18, 2002 6:28 AM
I am stuck with a project. I have included a web page
link below. Any help you can give me would be greatly appreciated!
www.geocities.com/cwknightcoach
I've been told that it can be done with simple VBA, but I
have no idea how to begin that. IS there someone who
would maybe want to give this a shot for me, or get me
started?
I would appreciate any and all help. If it's any matter
I do know how to program in Visual Basic 6.0.
Posted by Tom Dickinson on January 18, 2002 1:49 PM
For your rankings, put the followning in M5 and copy it down.
=RANK(L5,L$5:L$9)*3
This will give you 3 points for 1st, 6 for 2nd, etc.
The same type of thing needs to go in for LV (without the mutlplier). For the 40 column, use the same formula, inserting a comma and a non-zero number before the right paren.
You sorting request sounds odd. You can do a double sort such that the second item is used where there is a tie in the first category. But what you are requesting sounds like 2 sorts, and the second category sort will negate the 1st sort; or you will have the data separated from the person it belongs to.
As for you problems about ties, this will take a little programming. If you still need help with it, let me know.
