pear

Hi Guys, I would like help with creating a measure for the following data. I would like to categorize the products as i did manually for Apples - I calculated the total volume for the product and divided it by 3. Then I would like to start summing from the lowest volume of Apples to the highest...

Hi, I'm trying to accomplish the following results: <tbody> #8cb5df[/URL] "]January #8cb5df[/URL] , colspan: 3"]Publix #8cb5df[/URL] "]2019 #8cb5df[/URL] "]2018 #8cb5df[/URL] "]2017 #8cb5df[/URL] "]Fruits Pear 6 10 2 Mango - 1 3 Banana 4...

Hello! I'm having issues getting the correct formula to search a range and COUNTIF any part of a cell's text appears anywhere in the range. Using A as the search criteria and C as the range, I would expect the column B results below, but, in B2/B3 it's returning 0 no matter what formula I...

Is it possible to count number of instances of duplicate and unique cells found from a varied range using a list of data from another sheet as a reference to on what to look for? My data will be varied with up to 20,000 rows and up to 10 columns Also the cells will contain both numbers and...

Hi, Is it possible to Delete all duplicate cells from a varied range but keeping the original string and highlight it? I will have up to 10 Columns and up to 30000 rows of data which will contain multiple duplicates strings that need removing, There will also be headers. Can anyone Help? Thanks...

Hi, is there any ways to return unique value in excel using formula? For instance as below: <tbody> Name Fruit Abi Apple Abi Apple Rex Watermelon Claudia Orange Ricky Grape Abi Orange Rex Pear Count of Unique Fruit 5 </tbody> Unique Value Apple Watermelon Orange Grape...

Lads, Hope you can help me. I have Table in Sheet1 consisting of 100's of rows and about 20 columns similar to below. I need formula in Sheet2 that looks through Column A Sheet1 and if it finds APPLE IN CELL then it needs to copy whole row into Sheet2 and same for PEAR. This need to be in the...

Hi all. I would like to have a formula to replicate data from one row to one column skiping blanks. So I have in range A1:E1 ~~~> | apple | blank | pear | blank | orange | And I'm looking for a result like: B3 = apple B4 = pear B5 = orange Many thanks in advance

Hello, Hoping that someone could assist! I have a workbook where I needed to use the index/match function to source the data. While I was able to successfully complete the formula, I need that the formula also takes into consideration the dates. So for example, if the source data has...

RE: https://www.mrexcel.com/forum/excel-questions/1021341-vba-merge-duplicate-rows-sum-values-certain-column.html Tried the code here but doesn't seem to work well for my case. Example: <tbody> Room Quantity Description Small -- 2101 Small 1 Apple Small 1 Orange Small 2 Pear...

Hi, Looking for some help! Data set up as follows... Table 1 (sales data) <colgroup><col><col span="3"><col></colgroup><tbody> ID Product DC Month Sales Apple1 Apple 1 1 1500 Pear1 Pear 1 1 50 Orange1 Orange 1 1 30 Apple1 Apple 1 2 1200 Pear1 Pear 1 2 25 Orange1 Orange 1 2 60...

Hi, I have a large spreadsheet with 2 columns A and B <colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody> Name1 Apple Name1 Apple Name1 Apple Name2 Apple Name2 Apple Name2 Peach Name3 Pear...

I assume I need some ARRAY formula, but not sure how to do it. I have blank cells and cells with a value in column C and Column D is the formula I am trying to make. I want to move all values in Column C to the top of Column D in the order that they are in in Column C with blank cells being on...

I have two words in one cell in the data table, for example "apple pear" which have been concatenated from previous cells (in some cases I might have up to 6 entries) but in the pivot it shows as 1 entry. I need apple & pear to be 2 single entries in the pivot table. What can I put in the...

Dear Excel community, Currently I have a column that looks like this, <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> Mango Apple Orange Pear </tbody> Is there a VBA that can help populate the blank cells...

Hi Hope someone can help me please I have a spreadsheet full of data that is not totalled. I cant think of a way to do it. In total I need about 1500 totals so it will take a long time to do manually. See example below Each mini table of data has multiple lines (rows between them)...

Hello, I am looking for some help to combine two tables of separate data based on a single column with a 1:M relationship. I do not have power pivot, so I am defaulting to vba as the best option (unless I hear otherwise). Example: The two tables share Group as a common Key - the macro should...

Hi, I would like to be able to extract all values following one criteria but for the formula to automatically sort it. Please see below table to what I'm referring to. In table 1 would be the source data, I need to extract all the number and 4 digit letter based on the Order # & Fruit concat...

I have a column of data: Apple Orange Apple Apple Orange Pear How would I get excel to count and list out: 3 apple 2 orange 1 pear I know how to use countif, but that is if I am searching from a list of data. Sometimes there might be other unknown data inside, so I need to count and list out...

Hello, I'm trying to establish which two products are frequently bought together. I have the data in the below format: <tbody> Product(s) Apple Banana Orange Pear Apple 0 0 0 5 Banana 0 10 0 0 Orange 12 0 0 0 Pear 0 0 6 0 </tbody> So in the above, 12 customer's bought an Orange and...