sold

I have 400+ rows of data and want to use a formula not a pivot table to return value. I will be using the "color value" returned value in a different formula. data has item# on each row. any item number could be different colors (imagine a shirt with an item number 1111 that is available in...

Hello All, I have a table of a list of sales to customers and I am trying to create a formulae that will give me the total value of items sold to a customer. Table <tbody> Customer Record Type Item Qty Price Cust1 SI Item1 2 1 Cust1 SC Item1 1 1 Cust2 SI Item2 3 2 Cust2 SI Item1 5 1...

I have two worksheets , each of which contains data relating to my sales on eBay The first one I created back in 2011 when I first started selling. At that time I created a macro which identified which items had sold and which ones had not (the sold items were identified with "1" in a cell while...

Hi all, I have two sheets that contain products and the amount sold, I'm trying to sum the total items sold for only 5 items that sold most. Trick is I want to split the 5 items to sum between two sheets, on sheet1 sum only 2 of 5 (value in D1) <tbody> A B C D 1 # Rows Count 2 2 PA 15...

Hi all, I have a list of sale line items, one column has a date, the other the number of items sold. How can I sum number of items sold, where order date is <2/12/18 and >2/02/18 but instead of inputting the date, I would select a cell containing 2/12/18 (i.e E3) and tell the formula to look...

Greetings! I'm trying to create a rolling inventory for a series of products in a table that can be expanded indefinitely. Along the Y-axis are two groupings, products created and products sold. These are the only two ways products come and go. Within each grouping are a few empty cells, each...

Hello All, I have currently have trouble developing a VBA/macro that would do a search in a data range within a table and once search it will populate another range with the information I need. Below I have an example of what I am trying to do but can't seem to wrap my head around <tbody> A B...

Example: <colgroup><col><col></colgroup><tbody> SOURCE RETURN #5364 5364 #5571 5571 1 P/O#5159/1 WEB SALE 5159 20 SOLD P/O#5221 5221 24 SOLD P/O#4968 4968 24 SOLD P/O#5149 5149 3 SOLD P/O#5193 5193 36 SOLD P/O#5322 5322 6 SOLD P/O#5245 5245 lee tz qc P/O#4379 4379...

I'm brand new at using VBA. I searched for a similar problem here an in other forums but can't seem to find the exact issue. I have a workbook with two sheets. One contains inventory info ( product number, description, price and number sold). Sheet two contains product number, description, and...

Is there a command to copy values and update the destination range in case the values changes? Like I have a list of items that i sell everyday. Now not all of it are sold everyday, sometimes some of the items only in the list. What I what is something that will automatically copy the items that...

I have a spread sheet where in: column a I have the customer name in column i I have the sale person that sold to that customer. I am trying to list under the sales persons name on another sheet all the customers they have sold to. any help would be great ( I wish to avoid VB if poss)

Hi, I am a relatively new Power Query/Power Pivot user. I have pulled in four tables of data. 1. Sold To Master (one column with a unique list of IDs.) 2. Customer (Customer sold to information, including Sold To IDs (duplicates)) 3. Facts (Basically sales data, with duplicates of Sold To...

I need to figure out the formula in the Yellow cell that will total counts sold each day.

What I am trying to do is to create an additional column in a matrix visualization that looks at a UNIT ID and gets the AVG COST of that UNIT for a specific QTR by looking in the PRICING table and getting the AVG COST during that period. (A unit may have a price change in that qtr, multiple...

Hi, I am having a little trouble with my VBA code for my workbook and hoping someone can help. So I need the code to copy an entire line and paste it to another worksheet without cutting it from the original sheet. The criteria it is based on is in Column P and will be labelled as "Sold". The...

Hi I need to analyse many lines of data to see which products get sold together. I though a Pivot table would do the trick but having tried for a while, it doesn't seem to be the answer. So I have a sales orders with products on them. See below. I want to know that Salt & Vinegar has sold...

Hi, Good day all, I am preparing a forecast for next 10 years for my company. So I used activex scroll bars to control number of units expected to be sold. For example no of units sold in 1st year were controlled by an ActiveX bar and then the annual increase (by a %age) in no. of units was...

NEED TOTAL OF QTY FROM [A]+[B] TO [C] IN [C] HAVING A TO AK PRODUCTS NAMES WITH THEIR UNIQUE SERIAL NUMBERS FROM 1 TO 37. NOW LEFT SIDE IN [A] OR [B] HAVING SOLD ITEMS BY ONLY SERIAL NUMBERS AND WE NEED TO PUT FORMULA IN [C] FROM 1ST SERIAL NUMBER FROM SOLD ITEMS BY DATE WRITTEN IN [A] OR [B]...

I'm looking for some help on a sales pipeline report I'm working on. I have 1 worksheet that our sales team can enter their raw data and edit it as they move through different phases of the sales pipeline from Prospect to Quoted and finally to sold. On another worksheet, I'm trying to pull only...

Hi, I hope someone can help. I am trying to create a formula to yield a set result based on the figure of once cell, and I can't seem to get anywhere with this. Here is what the figures are: (Column A) (Column B) Products sold Amount paid <15 £0 15-19...