Hello everyone,
I'm having an issue where I can't seem to find a correct way of writing a formula to concatenate the values from a whole row without ignoring the "N.A" errors from the respective row.
For example I have 3 rows with "N/A" errors and one with correct input, I want the concatenated value to show only the correct input.
While on another example I may have two rows with "N/A" erros and two with correct input, I want that to showcase "Input1,Input2"
Do you think it's possible ?
Attached you have the example
Best regards,
Razvan
Bookmarks