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.
Feb 10, 2023 in Others 243 views

## 1 answer to this question.

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)
```

answered Feb 10, 2023 by
• 63,420 points

## How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

## In Excel, how to find a average from selected cells

If one has the dynamic array formula ...READ MORE

## How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

## How to use a named column in Excel formulas

Let's say I have the following figures ...READ MORE

## Calculate Monthly Highest Selling Product - MS Excel

Use a Pivot Table to summarize the ...READ MORE

## Choosing a random text value from a list

Try this: =CHOOSEROWS(FILTER(B2:B100,A2:A100=FALSE),RANDBETWEEN(1, ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE