apples

Hello all, I have this code so far, for concatenating values in a range: Function Concatenatecells(ConcatArea As Range) As String For Each n In ConcatArea: nn = IIf(n = "", nn & "", nn & n & ","): Next Concatenatecells = Left(nn, Len(nn) - 1) End Function Assuming I have this data: How...

Hello. I have been looking for an answer but obviously it is hard to find a case exactly like mine and I dont have the technical nous to change anything without screwing it up. If you can help I will be very grateful. I get an auto-generated spreadsheet from a software. This is a sales...

If I have the following all in cell A1 40 2 Apples and oranges How do I just get Apples and Oranges also the text could have varying number of text and the numbers at the beginning can also change to varying degrees. Thank you MM

Hi guys, I'm trying to do an IF statement to show "Apples" if a certain sumif based on a range is greater than another sumif based on a different range e.g. Oranges. And then it should show "Oranges" if the total value for the cells that correspond to "Apples" is not greater. Here's what I have...

Hello there, I know you can remove duplicates with the 'Remove Duplicates' tab, however is there a way to do it formula wise, including an if statement? For instance, in the dataset below, I need the unique values for each fruit. So, for instance, the unique values for Oranges would be 1, 2...

<tbody> A B C D E F G 1 Sales Amount Sold John Paul Adam 2 John Apples 3 Apples 5 Oranges 4 Oranges 6 Pears 5 Pears 4 6 7 Paul 8 Apples 3 9 Oranges 8 10 Pears 5 11 12 Adam 13 Apples 5 14...

Hi All, I am trying to work out a formula which allows me to return a value from a table based on 2 criteria with partial word match. I have an example below. I would greatly appreciate any assistance! Thanks <tbody> Group Date Apples #F2F2F2[/URL] , align: right"]10/2/18 </tbody>...

Hi I need to copy stuff from one worksheet to another according to the value of another cell. E.g. Row A says: Apples, Oranges, Bananas Row B says: 10, 5, 7 I now need to copy Apples 10x, Oranges 5x, Bananas 7x in Row A on another worksheet. Any ideas how I could accomplish that?

I was wondering, Is it possible within a Data Validation List, if you select an option in the top cell, for it to change the entire column to that option? Example: Say you have fruits in the list in column A: Apples Kiwis Watermelon But it goes down 100 Rows. Is it possible to Change Apples...

Noob ish user. I have apples in a1 and oranges in b1 I would like to show the quantities of each in c1 as an image <tbody> apples oranges image 2 2 two apples and two oranges 3 1 three apples and 1 orange </tbody> is there a way of making excel return the images of both items. I...

Hi Mr Excel, I like using SUMPRODUCT but SUMPRODUCT doesn't like blanks in my tables. It returns #VALUE ! when there's a blank. Is there a quick and easy way get around this, for example using the example below. Apologies for the cumbersome table posting... but cell D6 has a blank which causes...

Hello! I have six columns of values that I need to tally up by appearance. Some values appear more than once in a column and sometimes in more than one column. I've playing round in vlookup tutorial but cannot figure this out and would love to learn. Example: Column 1 / Column 2 / Column 3...

I have text in columns T, U, and V on a sheet called Tracking. In some of the cells I have “- Hold “. I would like to delete “- Hold “ and add “/ Hold“ to the end of the remaining text in the cell. Is there any way to do this using VBA? If not, what about a standard formula? EXAMPLE: <tbody>...

Table 1: <tbody> 1 A B C 2 Apples Oranges 3 Joe </tbody> Table 2: <tbody> 1 A B C D 2 Apples Oranges Apples 3 Joe 5 4 3 </tbody> I would like to be able to pull the sum of an array of columns if the two criteria (name and "apples" as the example) both match. So sum if Table...

The data entered are as follows : Total 5 4 6 6 Date 2/3/18 3/3/18 4/3/18 5/3/18 Apples 2 3 2 4 Oranges 3 1 4 2 In...

Hey all, I would love some help to put this formula together. I have tried and have not been able to figure out how to go about doing it... So I have a meal plan generator that tabulates all of the ingredients and groups them together, so if you have apples in more than 1 meal, all apples get...

I have this database with numerous different codes for the same listing: All Fruit............Fruit Code Apples..............AP1 Pears................PE1 Peaches............PC1 Bananas...........BA1 Pears...............PE3 Strawberries.....ST1 Apples.............AP3 Bananas...........BA4...

Hi, I am not sure if I should call this a comparison, but I am not sure where to start. Here is what I am trying to do. Lets say I have 1 column, column A. In column A there are many rows of IP ranges: 10.10.1.0-10.10.127.255 10.10.128.0-10.10.255.255 If a A2 row is within a certain range...

Hi, i'm trying to get an an amount allocated across a few lots based on its rank. I managed to do this with the formula below (table starts at A1). For apples =MIN(C2,$B$10-SUMIF($E$2:$E$4,"<"&E2,$D$2:$D$4)) For bananas =MIN(C5,$B$11-SUMIF($E$5:$E$7,"<"&E5,$D$5:$D$7)) Now instead of writing...

Hello I have three columns in a spreadhseet Column A is text Column B is numbers Column C is numbers What im trying to do is count numbers in column C is equal or over to the number in column B and is equal to certain text in column A such as apples Not even sure if this is countif? Can...