fruit

I have a requirement to create a mapping table that is based on 4 columns of my source data where the mapping can occur at 1 or a combination of multiple of those 4 columns. More specific rules (those specifying multiple columns or using the columns representing lower hierarchy levels) will be...

Lets say I have in column A, fruit names: Apple Banana Orange and in column B, I have price discounts for the corresponding fruit: $0.20 5% $1.00 If I were to do a look-up in column C, those prices end up being: 0.2 .05 1 Is there a way for me to keep the formatting? I can't format the...

Hi, I'm trying to work out a formula in which expands out a list based on 2 columns. Column A is the number of fruit, column B is the fruit and I want in column C a list of all the fruit. e.g. <colgroup><col><col span="2"></colgroup><tbody> Number of Fruit Fruit Result: 2 Orange Orange...

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

I'm hoping I can create a custom function to help me with a tricky Vlookup type problem: Let's say my vlookup should return the color of a fruit. I have a table on a hidden sheet that has each fruit with it's corresponding color. On another sheet, in cell A1 I have multiple fruit separated by...

Sorry for the horrible description, but if I knew how to explain it better I could probably look it up. But is there a function that will output to a single cell all the row numbers that reference a single description? In my example below, I'm trying to write a function for cells C7 & C8 to...

Hi, I have below requirement, can any one help; My data is like: Fruit Country Apple USA Apple China Apple UK Kiwi Germany Kiwi UK Grape USA Grape Canada I have to create two dropdowns Fruit: Apple, Kiwi, Grape Country: Populate Based on Selected Fruit I managed to create the Fruit...

Dear Members I registered today and this is my first post in the forum. if cell A1 to A5 contains fruits like banana, apple, grapes, guava, melon. and in cell A6 i want a random fruit from above 5 fruits, then what formula shall i use? Regards Pigeon INDIA

Hello All, I have been searching to no avail. I need a formula that lets me create a list of unique values but that has two columns. The first column has multiple categories like fruits and vegetables, and the second column has different kinds. Both columns currently have data that repeats. I...

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

Hi - I'd really appreciate some help with this as I've hit the wall. I need to identify matching items and number them (1 to x) by category. It's much easier to show you what I mean with a table below - please excuse the food based data points - it's for example purposes only :) I don't want to...

I have one sheet with a list of fruit then next 6 colums are marked week1 to 6 Fruit Week1 Week2... Apple 23 45 oranges 10 pears 5 6 7 on a second sheet I want to lookup the fruit and bring back the last row with data in it if I lookup apples it will return...

Dear Friends, I want a help for a formula which will calculate covered invoice Nos & Inv dates based on Fruit & that particular Fruit's stock. Giving an example below: Sheet1 <colgroup><col style="WIDTH: 30px; FONT-WEIGHT: bold"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col...

Currently I have a pivot table set up to show the top 1 of dates in the table. My question is, is there a way to filter the table to show the top 2 of dates if one of the value fields in the pivot table is empty using vba. For example if the pivot table usually shows the top 1 of dates, if...

Hi all - first post, would appreciate some help. I have an extract from SharePoint on Excel and I want to do a lookup against my Excel mapping table. The table I have in the spreadsheet is the "List from SharePoint" where I have a string with lots of # and ;s, I want to use that string and...

Hello All, I have a workbook that I download that contains a worksheet that has a varying amount of rows each time I download it. Sometimes I can have 10 rows, while other times, I can have 80 rows. This worksheet has a column named "Fruit" and the number and kind of fruits can vary. There is...

Hello, I'm trying to do either a sumifs or index(match() in order to sum a range of cells (multiple columns and rows) based upon a reference cell which can be modified to adjust the number of columns which are summed. For example, in the below table on the right are my results. Since A1 is 3...

how to calculate YTD with 2 criterias (i.e. heading is the month from B1 to M1 and Specific Code in the column A2 TO A10) Example A2 – A10 has name of the fruits B1 to M1 has Jan to Dec Each fruit has a value from Jan – Dec entered in B2 – M10 I want to get the YTD total of fruit if I...

Looking to set up a table as per below The values I would like returned underneath the "no. of fruit" I would like to pull from another table in a separate tab, which contains all weeks (1-52). In this table there are values for each of the type of fruit (has nothing to do with fruit really...