sold

HI question I'm looking for a dax formula that does the following i have a pivot table that looks like this customer number ,customer name ,Total bx sold 1234 jacks 53 Then i insert a slicer and i filter the total bx sold to the last 12 months I would like to add another column that...

Evening, I have a code which has a call to macro function at the end of it, the macro is shown below. Basically the cells C2:D27 show an un-ordered placement but then the macro once runs places it from most popular to least popular sold items. Now this works very good BUT i overlooked that the...

Evening, I thought i new what i was doing but ...... I have a range on one sheet as follows C1:F13 "split into 4 columns" C = name D = total sold "C1:D13" E = name F = total sold "E1:F13" Clicking on a button would copy info from range above "C1:D13" & "E1:F13" then sort from popular to...

Hi. I've been debating on how to do this but so far couldn't find a way. I have 3 columns, A, B and C. Column A show my buy and sell orders. Column B show how many products I bought and sold Column C show the price at which I bought and sold My goal is to sort columns A, B and C and transfer...

Hi Please excuse me if this topic has arisen before. I did do a search but did not see anything to assist me so far. I have a small restaurant and retail gift shop under the same roof. Keeping accurate inventory/stock control of the retail side is fairly straight forward even though at present...

I am currently looking at a transaction list data set where each line shows a location with an amount sold in an adjacent column. I have found out how to rank the values data so I know the amount the top location sold using =MINX ( TOPN ( MIN( 'Rank'[Order] ) ,VALUES (Location [Provider short...

Morning all, I am using the code supplied below which works fine. When the code operates i am taken to the worksheet where i currently see the message "LEADERBOARD" of which i need to click OK What needs to be done so i dont have to click OK,i dont even need to see this message BUT i do need to...

Hi, I have a list that contains many names of products (about 20k). I need to input the status (three options: bought, sold, expired). <colgroup><col span="2"></colgroup><tbody> A Name B Status Apple Orange Pineapple </tbody> I also have a list of bought, sold and expired items that...

Good Evening, today I came across the following problem: Say we have a table where the a-column is for example the color of a car, the b-column who sold the car and the c-column is the price it sold for.We now want to multiply the values of all red cars sold by Peter and here lies the problem...

This is similar to a question I have asked before. Basically, I have a list of products and the product number repeats on a new row for every price variance we have sold it for. I would like to find the price we have sold it for most frequently. Variables to account for would be: 1 - It has...

Hi, I need help figuring out the formula for the following case, I need to keep track of my inventory so I have a base inventory to wich I need to add the quantity of what is produced in a day and substract the amount of what is sold that same day. Inventory table <tbody> Code Name Qty On...

Sheet1, column-C2:C4 has the following values 359411083983706 452528741366222 521452282996963 Column-M2:M4 ..... INSTOCK INSTOCK INSTOCK Sheet 2, column-C2:C3 359411083983706 521452282996963 Column-M2:M3 Sold on 28-04-2018 Sold on 02-05-2018 i want a formula to compare/match column-C of...

Hi, I have a pivot table that shows Product Category & then Product Name in Rows. I then have the number of products that we have sold as the values with the name of who sold them in the column. My problem is that I want to be able to view just one employee and display the products they have...

I have stock buy/sell transactions and want to calculate my position. Here is some sample data: I can calculate most things I need but I'm struggling with Average Cost. So XXX bought 100 at $1 then sold 50 at $2, so my average cost is $1. Then bought 100 at $2 and sold 100 at $3 so I have a...

I have multiple rows with identical values in 3 columns and the 4th column has a unique value based on the date when it is sold. Can someone please help me in creating a 5th column which will show me based on conditional formatting value which was sold earlier and which was sold more recently...

Hi Everyone, I need a macro that can take 5 sheets copyinto a new document and then save that document as the name in range D7 and todays date. the sheets i need are Data, Totals, Sold, Returned, and Report. please help if you can Tony

Hi Everyone, i have a shhet and down column f we choose between 3 words "Sold", "lost" and "free" All i want is a formula to tell me which of those three words has been used the most so count number of "Sold", "lost" and "free" and if "free" is the highest give me the word "Free" etc. please...

I have three sheets, A, B , C.... Where in A I have values for all my products, in B I have the sold products, , in C I have the rest of the value which is the unsold products, all the values are scattered randomly on every sheet. Now I if I wanted to add a column in the sheet: A, that will...

Thanks to assistance in this forum, I now understand how to easily created a pivot table that shows months as columns. What I am now stuck on is to show multiple rows correctly. For example, I now have: Merchant Amount Sold for Januay Amount Sold for February etc What...

Hi Everyone, I need a macro that looks down column D and if a cell value is "Sold" deletes that cell and the one next to it (Column C) thanks Tony