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 C14:C103 only if the text 'Table 1' is stated in column J (J14:J103).
Hopefully this makes sense and can be done as I have quite a few tables I need to copy this across for of 8-10 people per table.
1 Reply
=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.
