Sep 07 2023 07:22 PM
How do I make one column for example column A take its information {date} from one column for example column B and if column B is empty it should take from column C?
Sep 07 2023 08:11 PM
@JW1234 You may try FILTER() function.
=@FILTER(B2:D2,B2:D2<>"","")