I have an excel sheet that I need help with. I have quite a few tabs, and they will be self explanatory in time.
The tabs are Final, Organized, Matches, Old, New, Archives.
This is where I am running into trouble, I don't expect everything to be done for me, but I need a step in the right direction for two formulas.
The first formula is:
- I have data that is entered into New and Old, I want them to have two outputs on Matches.
- Matches is broken down into two sections, Same and New.
- New are items that don't show up in old, and do in new.
- Same are items that show up in both.
- I need the search to depend on SO# and Part# before giving output, because there are going to be SO# that are the same, but Part# 99% of the time will be different.
- I want to have it in Organized where in Matches the new go first, and the old goes after.
Is this possible?
I can't use anything fancy like a Pivot Table, people here at where I work will shy away from using it if they see something that they are not accustomed seeing.
Thanks in advance.
Bookmarks