Remove duplicate number values but retain text value via vba

Hello.
I am currently using the code below to remove duplicate number values:

Please Login or Register  to view this content.

However, some rows do not have a number but instead an "N/A" and i would like the code to exclude any "N/A"s from the running code and just remove the duplicate number value.

All help on this matter is greatly appreciated.

Maybe:

Please Login or Register  to view this content.

The "N/A"s are still not showing up. The only difference is that before i had at least one N/A visible and now there are none.

Thank you John for your response.