I am currently trying to count #N/A in a column based off of 2 criteria in a different column. The excel formula I wrote counts them correctly
I adjusted code to also count and notify the user if #N/A errors existed before continuing to process the file. The code runs Ok but always creates the message box even when the actual count is zero. The count of #N/A is always in Column "AS" and the criteria is always in Column "V" using the text terms CSA Or GPA as the criteria If either one exists in Column V with a matching #N/A in column AS, then count 1 for each instance. I must have the code or format wrong. Can you help or offer a better way. Thanks
Bookmarks