Hi,
I am looking to use a formula which will eliminate the blank space or "0" if the criteria doesn't match.
I have a tracking spreadsheet which asks if the order is a Blanket order or not. If yes, then I want the order information to appear in sheet 2 filling out column B, C, D, and on wards. Attached hopefully gives an idea of what I am trying to do. I've tried an If formula, however for the orders which are not Blanket orders, come in as a blank space or "0" which means this spreadsheet would become massive, which I want to avoid. I have attached a template excel file.
Any help with this would be fantastic!
Thanks
Bookmarks