apples

This is all in PowerPivot 2010. I have an invoice table with: Invoice number, Part Number, Quantity, and Price. I also have two tables with: Part Number, Part Name. There two tables are because they are two different categories of products. I want to have a single column that will combine...

Hello, i'm looking for a cleaner way to use SUMIFS for multiple Tier structures. My formula in the table is =SUMIFS(Table2[Quantity Sold],Table2[Quantity Sold],"<="&B2,Table2[Quantity Sold],">"&B1) For Quantity sold, i am using =RANDBETWEEN(1,100000) just to fill the range of my dummy Tiers...

I am trying to get the countifs by using multiple column. I need to find out the number of times Column A and Column B. Column A with unique ID and Column B with multiple criteria. For eg. Coulmn A1 = Apples, Column A2 = Apples Column B1 = Orange and Column B2 = Peach Above case count as...

Hello, I have a the below table with x's (only mine is 100x300). <tbody> Adam John Fred Frank Apples x x x Pears x Bananas x x x Grapes x x Oranges x </tbody> I spend an hour+ each day copying and pasting into the below format by copying sheet...

Good evening all! I was wondering if anyone could possible offer a solution/guidance to a problem I'm having. I have 2 tables of data on 2 worksheets. I have 2 criteria that I wish to search, and for all matches, concatenate the values. Unfortunately I cannot use VBA, UDFs or addins for this...

Im using this formula to eliminate any blanks and return the most item value instead... {=INDEX(B2:B21,MODE(IF(B2:B21<>"",MATCH(B2:B21,B2:B21,0),0)))} (Array Formula) but it still returns blanks example in b2:b21 is - oranges x8 - apples x2 - pears x4 and blanks (no value) x6 (it should show...

Could use some help – I tried to simplify this down to explain I am using powerpivot and have three different types of fruits. I have set up measures to total the fruit, but I need to create a calculated column that determines what % of the quantity of each fruit is on each line The bolded...

Hi, How can I sum up each column based on the criteria inputted? What I've used is this but obviously not the most practical. =SUMIF(B2:B25,K2,C2:C25)+SUMIF(D2:D25,K2,E2:E25)+SUMIF(F2:F25,K2,G2:G25)+SUMIF(H2:H25,K2,I2:I25) How can I simplify this? <colgroup><col width="64" span="11"...

Hi I was wondering if anyone was able to help. I have a set of data in one Sheet and I need specific Data from that sheet moved to a second sheet and a comment added. So For example Sheet 1 has Columns A through E with all employees data. I would need this data moved to sheet 2, which has...

Hey folks, trying to build a sales report in Excel, which sums up all the sales on a product level. For each product I have multiple sales people, each of which has his own sheet. Lets say this is the structure: <tbody> Formula-Sheet Report-Apples Apples-John Apples-Mary Apples-Donald...

Hello, Does anybody know how to automatically highlight the highest value in each row label of a pivot table? In this example, I would like to highlight the highest selling fruit in each state. I couldn't find this option in conditional formatting. Thanks. <tbody> Sum of Amount Row...

Hey All I'm after a method of comparing two cells and seeing how similar they are, preferably in a percentage format based on the words in the cell. So; A1 = "Apples" | B1 = "Apples" - The result would be 100% A1 = "Apples" | B1 = "Banana" - The result would be 0% A1 = "Apples Banana" | B1...

So i already understand the function of mirroring cells into another sheet, but for what I need I need each cell from one sheet to be mirrored into another sheet but appear 3x in that column so for example Sheet 1: Sheet 2: Apples...

I have some rows of data with a bunch of duplicate text strings, like this (each fruit is in a separate cell): Company ABC Apples Oranges Lemons Lemons Lemons Pears Company DEF Orange Lemons Pears Pears Pears Pears Pears Cucumbers Company XYZ Apples Apples Apples Pears Pears Lemons...

Hi, Is it possible to split hyphenated and delimited text into the next row but keep the data in the same rows? example From This <tbody> What Who When Why Apples Pie Something A1-A3,A5,A7-A10 Banana Split Nothing D1,D2,D8-D9 Candy Cane Everything B1,B3-B6 </tbody> To This...

Hi, I have a table like below. I have a formula in another sheet that lets me know how many apples Bob bought on day 1 - it works great: =SUMIFS(Sheet2!C:C,Sheet2!A:A,"Bob",Sheet2!B:B,"Apples") BUT I need excel to sum the "month to date" as well to see how many apples Bob has bought so far...

Hi guys, I am new to Excel and would like to know what formula to use for the example below. I have a data table which includes the type of fruit, the size and the result. I know how to use the data validation function to create a selectable drop down list for both items, but would like to...

I have a Form that has a combo box with a sub form in it. When I select a item in the combo box the item history shows up in the sub form. My question is how can I get a running balance in my sub form? Below is what my Form looks like without the running Balance column. <tbody> Apples...

Any help would be greatly appreciated. I have a list of inventory (col A:C) with 3 criteria. I'm trying to figure out how to add conditional formatting to the table on the right (col E:I) that highlights the cells (g2:i10) if they are present in the list on the left. I've marked the cells...

Hi all, I know this goes against what pivot tables are meant to do, but for display purposes this is what I am trying to achieve: Data: ...