Nov 21 2022 08:14 AM
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?
Nov 21 2022 09:07 AM
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)