Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Quickest way to identify which items are in an Excel file?
Sorry for the vague subject line. Not enough space to explain in detail.
I have a large Excel file and a small Excel file. The main column I'm watching is a column for inventory ID numbers (SKUs). I want to identify the SKUs from the large file that are also in the small file. I could do it manually but that takes a long time. Is there a fast way to go through the large file and flag the lines that are also in the small file?
Thanks!!
2 Answers
- Donut TimLv 78 years agoFavorite Answer
Put the following formula in the next column to the long list column. It assumes the short list begins in column A and the long list begins in column E:
=COUNTIF($A$1:$A$25,E1)
Copy it down the long list column. It returns a total of the numbers in the short list that match the number in the long list in the adjacent cell.
. .
- 8 years ago
In the large file..........create a blank column.............
Use the VLOOKUP function/formula to check for SKUs of the large file that exist in the Small file.
Those that do not exist in the small file will return #N/A
