orange

Hi all, I'm looking to find a solution for joining (sorting and removing duplicates) multiple columns in one cell and then lookup all values in a separate table and return potential values in another cell. It would look something like this: <colgroup><col span="4"><col><col></colgroup><tbody>...

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...

I have the following data: <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Jan Feb Mar Apr Apple 1 2 3 4 Orange 4 3 2 1 Banana 2 2 2 2 Apple 3 4 5 6 Orange 5 4 3 2 Banana 3 3...

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 al, how to create a Pie chart with % and original value sample: Fruit Items % Banana 15 =(15/53) Apple 21 =(21/53) Orange 17 =(17/53) Total 53 Any Advice? Thanks

Is it possible to use SUBSTITUTE (or some other method) using a list of inputs? For example, my target cell contains the string <tbody> I love Apples, I hate Orange, my Banana, my Grape </tbody> and on another sheet I have a ranged list: <tbody> Apple Red Orange Orange Banana...

Hi all, I'm a relative newbie to VBA, macros etc and am trying to learn a few things, was hoping you could help/guide me in the right direction. I am looking to create a macro which will copy data from one sheet and then sort into the correct sheets with the specified data. For example, i want...

Hello Everyone, I have a userform in which i made two combo box, below are the name's ComFruits_Change() ComVeg_Change() Both combo box having informations like below: Private Sub UserForm_Initialize() ComFruits.AddItem "Apple 1" ComFruits.AddItem "Apple 2 "...

It's best to start with sample data: <tbody> Type Ripe_qty Rotten_qty Color apple 6 3 red apple 4 golden banana 12 12 yellow orange 31 orange apricot 14 13 pink apricot brown melon 9 1 green strawberry red plum 7 10 </tbody>...

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...

Hello...My name is Robert, and I am trying to discover a way for me to merge multiple CSV files into a single Excel worksheet? I don't want the merged files to appear as tabs on the bottom of the new worksheet. I simply want the data for each file to be stacked on top of each other. For example...

I am having a table with 2000 rows and trying to do a COUNTIFS to find how many combinations i have for the below example. With one criteria it is coming properly but when i add the next criteria it is not working. also i cannot type "Apple" i need to reference the cell since i have around...

I want to take the input cells, lookup their color values, then count the color occurrences. Probably need to use array but it's my achilles heel. Thanks!! <colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody> A B C D E F G H INPUT FRUIT...

Hi, I am trying to find a way to search a large sheet of data and then sum the values based on two criteria. For example I need to return the sum of colB for each Orange in colC in the month of "Jul" colA, IE 3 in this case. The month will be expressed MMM, but colA will be as below. Is this...

hi guys i want to know the last value of a row like this on my table <tbody>#DAE7F5[/URL] "] A B C D E F G 1 2 Table 1 in Sheet 1 3 2016 2017 2018 2019 2020 4 Apple 6,565.00 1,321.00 16,516.00 8,491.00 5 Grapes 4,819.00 51,651.00 15,651.00 1,984.00 6...

hi all, first here mi file: http://www.mediafire.com/file/kw8pbf17me0pqbh/Ejemplo%20Analisis%20ABC.xls second: i am follow this sample: https://ingenioempresa.com/analisis-abc/ my dude is: if you see in first graph, the color of the 2 fisrt bars is orange, this is based on 2 fist values, in...

Dear All, Need some help on retrieve unique values into column E. Please refer below for samples. i have tried vlookup and hlookup but can't work :( <tbody> columnA columnB columnC columnD columnE reference apple not not not apple watermelon not orange not not orange banana not not...

Hello to everyone. I have this situation (products / quantity / year) In column "I" i want to put quantity for these products which corresponding with year 2018 (cell "M2") Thansk's <tbody> A B B D E F G H I J K L M N O Products Quantity [kg] Year 00000 00000 000 0000 Products Qnty [kg]...

Hello. In columns C and D (C3:D600) I have a product list (about 25 different products) and in columns F and G (F3:G600) their corresponding prices. When product is in column C his price is in column F, and when product is in column D his price is in column G. In column I there is a list of...

I have to change the name as per the group in 'Type' column. it is working fine if it is represented as single name, but not with multiple names. Eg., For Apple, Orange, Watermelon, it should come as Medium, Soft Formula used in 'Type' Column -...