Hello,
I have the following problem, i need to remove values from column A that are present in column C without modifying the order in column B
To be more explicit below is an example:
Column A---------Column B-------Column C
5230400----------81,50----------1660000
3275500----------78,00----------6245700
2856300----------47,50----------5230400
1879800----------62,50----------2497900
2124300----------99,00----------1879800
2497900----------65,00
4826900----------77,50
2124200----------34,00
6245700----------61,50
3324400----------86,00
1660000----------53,00
Column A represents 600 materials.
Column B represents 600 prices. (different for each material)
Column C represents 107 materials that are present in column A and have to be removed along with their prices in column B.
Now i want to remove the materials that are in column A and C along with their prices, so i won't damage the order in the file.
Meaning if i delete a row in A and shift the other materials up or down, and in the same time column B remains unchanged, the remaining materials will have different prices...and that's not good.
If anyone could help it would be awesome! this is a common problem for me and i lose hours manually removing each material.
If anyone needs anymore details please ask.
PS: I'm using Microsoft Excel 2010.
Thank You a lot for your help!
Bookmarks