Sam Clough
New Member
- Joined
- Feb 9, 2014
- Messages
- 44
- Office Version
- 365
- Platform
- Windows
I am doing a Ranking schedule with 2500 ROWS plus the following Columns
Book 1 Actual Data which adds columns for various events. This works well
Book 2 Male Ranking
Book 3 Female Ranking
Book 4 Summary of all
I have buttons for
Male Ranking by Name
Male Ranking by Points
Male Ranking by State
Female Ranking by Name
Female Ranking by Points
Female Ranking by State
Overall Ranking by Name
Overall Ranking by Points
Overall Ranking by States
ale ranking by Name
Male Ranking by Points
Male Ranking by State
When I try to copy and paste Ranking Formula of =IF(D3="","",RANK(D3,$D$3:$D$300,0)) It inserts the apparent correct formula but comes up with #N/A on many of the Rows.
Can't seem to fix.
Anyone help?
Book 1 Actual Data which adds columns for various events. This works well
Book 2 Male Ranking
Book 3 Female Ranking
Book 4 Summary of all
I have buttons for
Male Ranking by Name
Male Ranking by Points
Male Ranking by State
Female Ranking by Name
Female Ranking by Points
Female Ranking by State
Overall Ranking by Name
Overall Ranking by Points
Overall Ranking by States
ale ranking by Name
Male Ranking by Points
Male Ranking by State
When I try to copy and paste Ranking Formula of =IF(D3="","",RANK(D3,$D$3:$D$300,0)) It inserts the apparent correct formula but comes up with #N/A on many of the Rows.
Can't seem to fix.
Anyone help?