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

0 votes
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 by Kithuzzz
• 38,010 points
234 views

1 answer to this question.

0 votes

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)

example

answered Feb 10, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

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

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

answered Sep 25, 2022 in Others by narikkadan
• 63,420 points
714 views
0 votes
1 answer

In Excel, how to find a average from selected cells

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

answered Oct 9, 2022 in Others by narikkadan
• 63,420 points
462 views
0 votes
1 answer

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

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

answered Oct 24, 2022 in Others by narikkadan
• 63,420 points
758 views
0 votes
1 answer

How to use a named column in Excel formulas

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

answered Oct 24, 2022 in Others by narikkadan
• 63,420 points
304 views
0 votes
1 answer

Calculate Monthly Highest Selling Product - MS Excel

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

answered Nov 12, 2022 in Others by narikkadan
• 63,420 points
1,334 views
0 votes
1 answer

Choosing a random text value from a list

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

answered Apr 3, 2023 in Others by narikkadan
• 63,420 points
154 views
0 votes
1 answer

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

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

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,237 views
0 votes
1 answer

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

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

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,425 views
0 votes
1 answer

How to find a value in an excel column by vba code Cells.Find

Just use: Dim Cell As Range Columns("B:B").Select Set cell = ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
• 63,420 points
2,886 views
0 votes
1 answer

How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Use VSTACK: vstack to make an array: Use it as value ...READ MORE

answered Mar 18, 2023 in Others by narikkadan
• 63,420 points
269 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP