Excel Macro #N/A

[Sam Clough]

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?

 

[Sam Clough]

I am sorry I am not more astute at this Book.

I too have been bashing my head against a wall (love the Icon).

Can you download and help?
https://www.dropbox.com/s/6zeewutps3...m%20Final.xlsm

 

[MARK858]

See post #20

 

[Sam Clough]

Mark858, You've done it, I believe. Had to change that last number in all 3 pages (I went right down to 2500 for future additions.)

I am impressed.

Thank you so much.

Sam

PS - Is it possible to remove the link from the website (that info is a bit confidential)?

 

[MARK858]

PS - Is it possible to remove the link from the website (that info is a bit confidential)?

Ask a Moderator how they want you to do it, whether they prefer you to remove it in your Dropbox or they want to remove the links from the threads themselves as generally any links are left there to help others.

For future reference if you post on any public forums scrub or replace any sensitive data with fake data before you post anything.

 

[Sam Clough]

OK, thanks Mark. As you might realise, I haven't used anything like this site before. Brilliant.