Is there a way to replace all the #N/A results from any formula? If you try
to use #N/A in the replace function, Excel doesn't recognize it. The only
work around I could come up with is to sort the column with the #N/A's and
then delete or copy over them.
Thanks, Sandy