Google Spreadsheet Excel - how to find matching values in column A having necessary values in column M

Question

I have a list of product articles in column A, and I have extra product information in columns B through L, for a total of 95000 lines. Additionally, I have column M, which contains a list of 3000 items that I must locate in the column A list. How can I only highlight values in column A that match values in column M?

I tried using conditional formatting, but the file is too large and it takes too long to complete any tasks.

Answer 1

Try this:

=COUNTIF($M$2:$M$5;A2)

If the product is present in the column M list, it will return 1; otherwise, it will return 0. you may then use column N, which has 1 as a filter.

Be aware of your data set; the actual formula you must employ will likely like the following:

=COUNTIF($M$2:$M$3000;A2)