Hello to all and I am a basic neophyte when it comes to Excel (2010) but I am computer proficient. PLEASE help me with this as I use (and help) other forums and find very smart people out there:
I have 2 spread sheets
Sheet #1 I have info on columns a-i (1264 lines) column A has item numbers (6 digits)
Sheet #2 I have info in columns a-i also (14,989 lines) column A also has item numbers (6 digits)
All of the item numbers in column A sheet #1 are contained in sheet #2 but since the numbers on both sheets are not even close to consecutive as many 6 digit numbers are skipped on both, this is where my issue arises. Again the 1264 numbers in sheet #1 are ARE in column A of sheet #2.
How can I line up both column A's matching numbers on the same line number so the merged sheet will now have columns A-R with the item numbers matching. I can end up deleting all the excess information after this function is done. Also there are no formulas in either sheet just raw data. I hope this is not confusing and THANKS in advance!
Please help!!!
Perhaps one way...
On the sheet with more rows (let's call it Sheet2), enter in a new column, say J2 a formula to determine if the item number matches that of the sheet with less (let's call it Sheet1), the formula would be like:
=Isnumber(Match(A2,'Sheet1'!A:A,0)) copied down
TRUE result means item found.
You can then apply Autofilter from the Data menu and filter For FALSE to see which didn't match and do further work from there.....
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
From PM
If what I mentioned already won't work for you... then probably you will need VBA which is not my expertise right now.Thank you THANK YOU for replying to my post yesterday and I still cannot get this done I am hoping the new explanation below can make this easier. I you can help with this GREAT!
1) There is a spreadsheet with columns A-S (A-I is one group and J-S is second)
2) A-I has 1254 lines
3) J-S has 14,889 lines
4) Column I and J have numbers 4-6 digits. All the I numbers are contained in the J numbers but there is no consecutive order.
5) I need all the numbers in J to line up with the numbers in I (I are the main numbers concerned about sort order)
6) All columns J-S must stay together after sorting and of course A-I which should be natural.
All the excess numbers I do not care about and will delete after. If attaching the file would help I will.
Maybe a small sample workbook with what you have and expect would help clarify.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks