Hello,
I need help creating a formula that scans one column searching for cells that contain the letter X, Y, and Z. Then finds columns where X or Y is false but Z is true. The final result would be the column heading of the first column that was different.
Example:
Column "J" contains X's, Y's, and Z's and columns “L – T” contain True or False results and have headings numbered 1 through 9. The formula would check if there was an X or Y in its row in the cell for column “J” and if so it would look for instances in columns “L – T” were either X or Y were false but rows containing a Z were true. The heading of the first instance this occurred of said column would be the result.
A spreadsheet with an example is attached for a better understanding of what I'm trying to accomplish.
Thank you in advance for any and all help.
Bookmarks