Hello
I found this solution (IF(Z5="",Z5,Z1&Z5)) in another post about linking IF with concatenate.
I was wondering if you could do this for a number of cells and combine the results in a single cell?
I'm looking at some survey data and I'm trying to:
- find those cells with data in them (e.g. responses to a question).
- then, if this is the case, concatenate the question with the answer
- then combine all cells where there are answers into one cell
Is that possible? I've looked into nested IFs but couldn't get it to work.
Many thanks in advance.
Jeremy
Bookmarks