Advanced Filter Comparing Two Columns

[jswhip]

Is it possible to use "Advanced Filter" to compare two columns in the data range and keep if the values are the same? Trying to use Advanced Filter and avoid creating another column of data with which to do my comparison.

For example, I want to compare columns M and S and keep the rows where the values are the same.

 

[arthurbr]

As newer XL versions have new tools, please tell us ( and update your profile) which version you are using. With XL365 the FILTER function can be used