Forum Discussion
Copy text to new cell if column states certain text
I need a formula to copy a guest list into a seating chart: I have a work sheet named 'seating chart' and in range C12:C21 i would like it to copy any of the names in work sheet 'guest list' cells...
=FILTER($C$14:$C$103, $J$14:$J$103="Table 1", "")
If the text Table 1 is stored in a cell, say B12, you can use
=FILTER($C$14:$C$103, $J$14:$J$103=B12, "")
This can be copied to other cells if necessary.