Most valuable professional
  • Hot Topics

Excel Excel Macro #N/A

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.

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of February 9, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel