Having Match Search A Full Column
I'm currently trying to use the Match conditional in order to compare two columns of data to identify where they overlap. At the moment, the formula I entered seems to be working properly however it is only applied to the row it occurs in. Given that the column I'm searching is a few thousand rows longer, is there any way I can avoid a manual sort and modify my formula in order to get the results ...