I have a table something like this (much bigger in reality)

1 5
2 10
5 15
7 #N/A
9 20
12 25

I need to interpret the above data with the linest function, but for a variety of reasons i cant delete the error square. How can i get the LINEST to ignore the #N/A and the 7? otherwise it returns an error.

Many thanks in advance


Andy