Sheet 1 contains all the names that are going to be used (around a 100 but in different forms as stated above) and sheet 2 contains all these 100 in multiple rows plus names that aren't in the 100 list and therefore I don't care about. Now the problem is that the names don't match perfectly. I want to consolidate these two sheets into a master sheet based on this Name column they both have, so the consolidate function is perfect for this. Each sheet has different kinds of information. Each row contains a Name column and then several columns that contain information about this Name. I have two sheets with many rows (one with 800 and the other with 300,000). I can't even break down the problem properly. Okay, I have been trying to find a solution for this and I just don't seem to be able.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |