orders

Hi All, I'm familiar with SumIf and CountIf but not AverageIf, so wondering if this is going to work for what I need? I have 2 columns. Column 1 - Order No.s (these may appear more than once if orders get split but the original order number remains) Column 2 - Sales Value I want to be able...

Hi all, I have a 2 column table which contains customer names and order values. As customers place more orders, they are added to the table, therefore I have multiple entries for each customer. Can someone advise on how I can retrieve the customer name and cumulative total for that has the...

Hi, My data lists customer names in Column A, and in column B lists whether the order is complete or outstanding. I'm after a formula which counts customer A has 6 completed orders and 3 outstanding or Customer C has 3 competed orders. I'm shrugging to get this formula to work as it has two...

I have orders numbers each orders in a row, and email for each order , 34k individuals made 290k orders for the last two years , I would like to sort by each individual by email and add total orders nr and amount and the number and amount of each order Can you please help on this? Thanks

Hi there! I have a table like below: <tbody> Order Date Brand Product ID Customer ID Supermarket Sales Volume Sales Value ($) 01/09/2016 Company A 3431 345452 Supermarket B 5 10 02/09/2016 Company A 3524 243784 Supermarket B 2 4 02/09/2016 Company B 3122 345452 Supermarket A 1 2...

Hello All, I am trying to count orders placed from one sheet in a workbook to another sheet. I'm trying to do it by part number and month range. For instance, I have sheet1 that I keep a running tab of orders placed; part #, date ordered and quantity. On sheet two, I have; description, part#...

Hi, I am trying to create a way to track volumes for orders received for multiple products against orders completed on a daily basis. I do not need to track the order details, just the overall number received/completed for a day. I currently have 3 sheets - 1. Orders received (table with list...

Hi, I have a spreadsheet which shows outstanding purchase orders. I would like to create a button which, once you press it, means only overdue orders are shown. When I do the record macro option and do the following: click filter on "due date" column, number filter, before today - it doesn't...

Here is my question...I have a workbook that my sales reps use to input orders...we sell a variety of promotional products. What I need is when the sales rep is placing an order for apparel, on the cost sheet where they put all of their information, which then populates the estimate and P.O...

Hi I need help in solving the below issue. I have stock of product say "X" 100 units. I have 5 different orders for 80 MT. This stock should get adjusted to these orders with certain criteria say earliest ordered date. like this I have n number of products and there will be orders for these...

Hello, I am currently manually creating a list in excel that is taking a very long time. I was wondering if there is a way to automate this. Please see below for an example. Thank you so much for your help! Columns for the criteria: <tbody> Name Number of Orders Placed Justin 2 Bob 3...

Im new to macros. Ive used the recorder a lot to help with simple macros of if a do b, but i need a better macro for this issus and i cant seem to get the macro to do as i want. Here is what im trying to do : I have data that located in column A So if. W = numbers of orders, and x is the...

Hello, I had created an report to follow up my orders, this report take the data from database, i would like to mark the new orders witch added after last update by "New*" for example. my data looks like: <tbody> <tbody> Order ID </tbody> <tbody> Order Date/Time </tbody> <tbody>...

Hi All I'm currently working on some vba and encountering a issue that I can't find a answer or solution for I have within a workbook several tabs The tabs in Questions are Open POs and PO Orders My code is as follows Sub CopyData() Dim LR As Long, ALR As Long Dim MSht As String, DSht As...

Hi All, I've used this site for years to search for answers to formula problems I've had and loved it. But now I'm trying to find a formula to calculate a productivity based on 2 different volume metrics and I'm stumped! So the basic productivity calculation we use is ORDERS / HOURS = hourly...

https://imgur.com/a/WsMJj Hi all, Above is a screenshot of the sheet that I am using to calculate payments. I want to put a formula in B13 that automatically works out the weekly fee that each client has to pay. The weekly fee is determined by the total number of orders (cell B4) and you can...

I need a big help on this I have a spreadsheet called "2017 Funds Journal" and that is where I enter all order for the whole year, another department needs the invoice number and order amount from this spreadsheet so they can upload for invoice processing. Instead of having to update this file...

I have a workbook that I update often entering orders for each date, and it have all our orders on it, then I need to create a separed one to load the only daily orders, that one i will upload on our invoicing system. I was hopping someone can assiste me with that. I would like to have this...

I have three connection queries. One is called Work Orders, One is called Time Keeping, and the other is All EE. Currently I am merging Work Orders, and Time Keeping on Work Order # and creating a new query, then merging All EE with that new query on Employee ID. IS there a way to Merge all...

Hello, I have hundreds-of-thousands of rows, which most of them have missing values (column 2). Based on a primary key (column 1), I can assume that the missing values can be imputed with values associated with that key. An example would be necessary. <tbody> Primary Key Date Date.Impute 123...