How can I create 2 columns with distinct date ranges? I have 1 table with my dates and units and I want to show the units sold for 1 week in 1 column and the next week in the second column and then calculate the change WOW. I don't know how to have two date columns from one...
I have a spreadsheet with 214 rows til now, with 10 units of data on each row, 5 numbers and 5 letters. The numbers go from 01 to 1237 and 80 letters from A to CB. I need to make a table with the number of occurences of matched pairs and triples. I would like to know the number of times that 2...
Trying to keep this example simple.
I have a pivot table:
I am trying to combine information in a spreadsheet from three pivot tables using the VLOOKUP.
However, when I try to display the...
Hi all, Happy Friday!
I was asked to work out a formula based on multiple conditions and for the life of me I can't work it out. I think I'm over complicating it but I was thinking an INDEX and MATCH formula would work. I know I can just do a simple lookup to get the results but in all...
Hi All! I am new to this forum. Need help.
I need to separate units from quantities. i am not being able to do it because cells that are custom formatted and no text function works on these. When converted to text format, the units automatically disappears! Can you please help me out on this.
Hi, I'm having an issue with a DAX formula limited to TOP!%. But produces more that 15 lines. Could it be because I have a filter on the PIVOT TABLE for location. But need to add it to the measure?
The measure below should provide me with the TOP 15 Brands sold for the day...
Hi, I’m trying to build a measure to list the TOP 10 models and what our inventory levels are for those items.
I would rather use CUBIC formulas but since the list of the TOP items changes each day I am limited to a Pivot Table. I could have another pivot table and use a vlookup. But that...
I hope someone can help.
I have a large XLS and I have a table of unit prices and then a separate sheet with costs by year. The problem is that each year is a single cell and the number of units increases by 10k each month. Is there a formula that will allow me to derive the yearly...
I want to apply formula in the column A Units and wanted to skip units if Values in column B is between -0.5 to 0.5, please help based on the...
Hey all - just a basic question that I'm blanking on for some reason...
I have a pivot table that refreshes that shows me how many units I have sold through out the year with the total units sold in cell F75.
I have another calculation in cell G76 that shows me what % of the way we are through...
I'm having trouble figuring out a formula that will distribute my total number of units by weight. I need to round the result to the nearest whole number but I also need the total units once distributed to sum to the proper total.
I am trying to use a vlookup up to calculate whether a capital gain or loss has been made or lost when selling shares. A major problem I have is; if shares are purchased in two separate lots and at different prices, when I sell a portion of the shares I need...
I am trying to use a vlookup up to calculate whether a capital gain or loss has been made or lost when selling shares. A major problem I have is; if shares are purchased in two separate lots and at different prices, when I...
I have created a Data Model from a block of data.
The warehouse guys work from 17:00 to 04:00 daily, what's the best approach to obtain the units picked but displayed in one pivot table?
I can achieve this over 2 pivot tables using filters but ideally I want this in one table.
I have a nested if statement to return values once a certain number of units are deployed. What I'm having trouble with is how to structure the formula so that is returns zero once the condition is met. So for instance, the first time units deployed hits the 23-28 range, then return...
Hi, I have exported accounts data in excel from accounting software. Now stocks of the items are in Cartons (boxes); please help me, how to convert them into KG because record of all other items is on KG only. Please see attached excel sheet.
I can get the sum of boxes for desired products but...
I have a problem where I am trying to produce a certain number of units, however the available capacity does not allow all of the units to be produced each month and they need to be produced in order of their ranking from 1 through 6.
The ranking of the units to be produced changes from month...
I have a client name in 3 or 4 rows. Each row has a different service with different units and unit price. I want to have each client have one row, and the service hours and price in different columns. Example
Smith 3 units $5.00 per unit
Smith 4 units $3.23 per unit
Smith 3 $5.00...
I am trying to get a total of units sold for a particular UPC. The units are not summed up before they reach me, so vlookup does not work here--first I need to get the total of the units, and then I need to input that total. I usually use a pivot table for this, but recently I've run into issues...