orders

I'm working on a project where I need to count unique distinct values that meet more multiple criteria. In this instance I need to look at: Orders that were placed in 2014 Unique customers that placed Web Orders I am trying to determine how many units (rooms) each unique customer...

Hello everyone, Nice forum you've got here, I hope my first thread will be useful for others with similar problems. I need to count how many different values are there in a column which meet a condition. I intended to use this formula...

Working on another project for work where I need to look at over 25K rows of data and perform a count of the Unique Order Numbers that made up our Web Orders in each of the last 4 years. My file has 2 tabs. One is labeled "Sales History" and the other is called "Metrics". The "Metrics" tab is...

Hi, I have been trying to reference a list of orders into a time line plan for a product. The report data is listed by part number and re-occurs based on different Purchase Orders (POs) - image Order List — imgbb.com My time line plan is organised by part number - image Time Line —...

I have a simple warehouse stock workbook. One sheet has the parts inventory, a second sheet has the orders. The second sheet (called ORDERS) has orders fulfilled such that the part number is in the first column and the number ordered for that part in the fourth column. I want the inventory...

Dear All,</SPAN> If you can help me kindly: I have an excel report with the following head columns (I will highlight only the ones that are needed for the end result):</SPAN> A1: Request ID ; D1: Request Status ; F1: Request Entered Date ; H1: Request Resp. User ; K1: Last Updated Date ...

Hi, I work for a manufacturing plant where we manufacture one product which is then sold under different names. The product is made from the same material. I am looking for a way to match up production to the orders and then subtract the produced quantity from the orders. Tab 1 - Orders...