I am working with an invetory spreadsheet.
Column "A" contains the style number.
Column "C" is a variable "F" for current items or "D" for those items that have been discontinued.
Column "D" is the various sizes.
Column "G" is the current amount of stock in that particular style and size.
I am looking to remove unnecessary data from the spreadsheet. What I need to do is remove all discontinued styles that do not have any stock. However, if one size in a particular style has any stock the entire style set needs to remain in the spreadsheet. Any suggestions?
Bookmarks