I'm just wondering how a formula would work where I am wanting Column A says "X" where the same rows in Column B says "Y"?
This is for 500 datasets and I require the answer to be displayed in another column, which appears on a different worksheet, not sure if this affects the formula much.
Thanks
Bookmarks