Populate value from a row if it is a number

[kellyfirth]

I need a formula which will search through a row and if it doesn't say #N/A #N/A then it will populate with that cell.


Does anyone know of such a formula to make this work? Many thanks!!!

 

[RonB1111]

Is this what you're looking for? (If not please clarify with some sample data and expected results):

=IF(COUNTIF(A1:M1,#N/A)>0,#N/A,"No n/a's in row")

 

[kellyfirth]

Yep, this worked perfectly! Thank you :D

 

[RonB1111]

You're welcome!