sheet.PNG
Hi everyone. In the table I have depicted above, I am trying to make the values in column C shift dynamically when column B gets updated.
Use:
1) Values are input into column A. Column B then sorts these using a SORT formula.
2) Y or N values are input into column C in respect to the value in column B.
3) Later on, I add another value into column A, cell A10. For example, value "alpha".
Column B will sort this, and place "alpha" in cell B2, pushing "hotel" down to B3.
Column C will stay as it is, but this is not what I want. Is there a way for the values in column C to dynamically move so that the entered values shift with their corresponding cells from column B?
Please find sample spreadsheet attached.
Thank you for your help!
Bookmarks