Greetings All,
I have read numerous threads on this site, and it seems that the people who respond are very knowledgeable. I have hit a huge road block and have no idea how to solve it.
Ok, I will try to explain this as best I can, and more than willing to post examples if need be. I am attempting to located the values in Col A, of spreadsheet 1, in Col A of spreadsheet 2. Now, sheet 1 is set up with row headers as well as col. In sheet 2, the headers (col and row) from 1, are side by side. What I need to do is find a way to count the instances that the col headings occur in sheet 2, and input that number in sheet 1.
Example:
Lots Receiving Complaints (2010) Counterfeit/Diverted Product Child Opened Damaged Coating
0013A61 3 2
0013A62 5
If this is unclear, I apologize. The above is an example of what I need sheet 1 to look like. Sheet 2 looks like this:
0013A61 Counterfeit/Diverted Product
0013A61 Counterfeit/Diverted Product
0013A61 Counterfeit/Diverted Product
I have tried doing this manually, but there are over 1800 rows I need to look-up, and it's taken my 3 days to get through only 200 of them. It's very time consuming, not to mention tedious. I was wondering if there were a way to speed up the process. Your help is greatly needed and very much appreciated!!!
Thanks in advance!!!!
Bookmarks