Forum Discussion

Monique29's avatar
Monique29
Copper Contributor
Nov 21, 2022

repeat data conditionally from other columns

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?

 

excel

1 Reply

Sort By
  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Nov 21, 2022

    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)

     

Resources