As the title suggests i'm trying to return any value that isn't #NA from 10 columns. There only ever be one value, with the other 9 columns showing #NA.
I've tried using IFNA but can't figure out how to use it for multiple cells.
I've attached a example spreadsheet. The column in yellow is the result i'm trying to achieve.
Many thanks
Bookmarks