Identify matches between sheet columns

batman1 · #8 01-29-2025, 04:22 PM

Quote:

Originally Posted by gmaxey

I tried to attach the file previously but it is too big. I was able to get your code to run but the result when run on my test file only returns 22 rows when it should return 43. I was able to post the test file here:

Identify Matches between Sheet Columns (see post #6)

It is a pretty complicated process (for me at least) and the example I asked about was a feeler to see if there was a way to do it without loop through all of the rows (speed enhancement). I believe with some slight mods that your approach might work, but it stills does a lot of looping and I'm not sure if in the end there would be that much improvement in speed.

Thank you for sharing your ideas. I have used a dictionary before but clearly not as proficient with them as you. Well done!!

1. I understand that the value to search is in Sheet NDS_SHEET, but exactly in which column? Maybe it's just part of the cell value?
For example, let's take row 5 in NDS_SHEET, the value to search for = ???
2. We already have the value to search for, but where do we search in sheet REF_SHEET?

It is best to attach a file:
1. NDS_SHEET with 20 rows of data
2. REF_SHEET with 100 rows of data
3. Manually enter all matches in the RESULT sheet

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Remove the subtotal columns in a sheet	Marcia	Excel	3	12-01-2023 05:48 AM
Relating cells in a row in one sheet to cells in columns on another sheet.	mbesspiata3	Excel	2	01-06-2017 05:42 AM
Create a New Sheet from Existing Sheet with Specific Columns	malam	Excel Programming	1	10-17-2014 10:01 PM
From an XL sheet ,how to keep the group of columns which match with other XL sheet	Zubairkhan	Excel	2	03-04-2014 10:57 PM
Removing columns within sheet	shabbaranks	Excel	2	09-11-2012 05:03 AM