Forum Discussion
Which Formula do I need?
I have a spreadsheet that has 5 columns of data but there is only going to be 1 answer in a column in any row, I am going to create an additional column, what I need is this column to show the answer...
Let's say the answers are in columns D to H, starting in row 2.
In another cell in row 2:
If the answers are numbers or dates: =SUM(D2:H2) or =MAX(D2:H2)
If the answers are text: =CONCAT(D2:H2)
Fill down.