repeat data conditionally from other columns

Copper Contributor

Please, I would like to copy data from two or three columns into one, indicating that one of the columns has priority over the others, when its cells are filled with data. Is it possible?

 

1 Reply

@Monique29 

If your data is in column A, B and C and A has priority over B and B over C, then your function could look like this.

=IFS(A1<>"",A1,B1<>"",B1,TRUE,C1)