Hi, there must be a not too complicated way to do this via formula, but I can't get the combination right.
I have a table which displays Name values in a Column B, with some repetitions. In Columns G through M for a given row, I have multiple choice values from four options. What I would like to do is map this table to a new tab, in which duplicates are removed from the list in Column B (showing only one row for each name), BUT, utilize an IF type function where if two of the options appear on the inital tab (In columns G through M) next to ANY of the rows with that particular name, I can return a simple NO (Otherwise, display YES).
If someone doesn't understand what I am asking please let me know and I will try to clarify. Does anybody know how I can accomplish this? Thanks!!
I have a table which displays Name values in a Column B, with some repetitions. In Columns G through M for a given row, I have multiple choice values from four options. What I would like to do is map this table to a new tab, in which duplicates are removed from the list in Column B (showing only one row for each name), BUT, utilize an IF type function where if two of the options appear on the inital tab (In columns G through M) next to ANY of the rows with that particular name, I can return a simple NO (Otherwise, display YES).
If someone doesn't understand what I am asking please let me know and I will try to clarify. Does anybody know how I can accomplish this? Thanks!!