copying values ignoring the cells with #N/A

[snoopyngd]

Hi,

Can help with copying and pasting cells that contain only numbers ignoring the cells with #N/A values?
Or
How to use the LINEST function if the data contains #N/A values?

thnx.

[stnkynts]

Something along these lines will do:

Please Login or Register  to view this content.

Of course you will need to edit to match your ranges and/or configuration.

[snoopyngd]

Something along these lines will do:

Please Login or Register  to view this content.

Of course you will need to edit to match your ranges and/or configuration.

It worked great, thanks!