Please help. I have an inventory spreadsheet that has partnumber in one column and quantity in another column.
Part# Quantity
1................4
2................3
3................1
Recently I did a physical count of the inventory and came up with quite a few quantity changes:
Part# Quantity
1............7
2............1
3............25
Is there an excel function or forumula that can compare these 2 sets of information and update the partnumber's with the new updated quanitities?
I have over 1000 parts and don't want to manualy make the changes.
Thank you for your help.
Part# Quantity
1................4
2................3
3................1
Recently I did a physical count of the inventory and came up with quite a few quantity changes:
Part# Quantity
1............7
2............1
3............25
Is there an excel function or forumula that can compare these 2 sets of information and update the partnumber's with the new updated quanitities?
I have over 1000 parts and don't want to manualy make the changes.
Thank you for your help.