fruit

I'm trying to learn some new formulas & have come across SWITCH. I know how to use VLOOKUPS I have a list of names of Fruit in Column A - in A1:A5 & a list of costs for each next to them in B1:B5 In D1 I want to type some fruit e.g. Apple, which is also in A3, the press Enter when I have...

Please help me out. I want a vba that can automate this process that copy sheet2 to sheet1. For example on sheet2. Column D4 fruit column separate by a blank line with a new fruit with dates, purchase orders and quantity. There's six types of fruit that I need to keep track. What I want to do...

I am wrecking my brain over what formula to use to summarize data (into a chart) using the data tab. Below on the Summary tab I would like to know how many Fruit, total AND individual, do I want and how many I've purchased for each date. As time passes, I will change the date in Row 2 and I...

Hello, I'm trying to essentially do something similar to a vlookup, but instead of it just returning a single result, I want to see all results. I would like to have each result show in a different column. Here's what I have in mind: Basic Data Set <colgroup><col width="64" span="2"...

Please help, I’m trying to accomplish the same result in this table with a formula when looking for thousands of data. Year Fruit Jan Feb March 2018 Banana. 1. 2. 3 2019 Banana 2. 3. 1 2018 Apple 4. 4. 4 2019 Apple. 2. 5. 3 Thanks

Hi all, I am trying to figure out if there is a possibility to find a solution to the following example: Let’s say that we have a table with input data including words and numbers. In that case that I need is for following up engineering cases. The problem is when you added a new case and it...

I'm wondering if anyone can help me with working out how to add a hyperlink based on certain conditions. I have two worksheets - Worksheet "Catalogue" has a dropdown list to select which fruit and another worksheet which has information about the piece of fruit selected. There are multiple...

Hi All, I can't figure out how to word this to search properly, so I haven't found something even though I'm sure someone's posted this before... I'm in the process of converting a list to a grid, based on the values in the grid. I've done this before matching 1 criteria, but having trouble...

hi guys, new to the forum.... im trying to code up in VBA but stuck at the moment hoping to find answers... basically i have this worksheet tab call "Fruits", with a column header starting at cell A4 call "Fruit Types", and subsequently A5, A6 onwards have different names of fruits. Basically I...

Dear All, Kindly help me to solve below mention problem. In column A- master code from A2 to A In column B- master code of fruit from B2 to B In column C - list of fruits based on user entry Procedure - Search column B name in column C, if name of that fruit present in column C then copy name...

I have a table ("Fruit") in sheet "Fruit" which is comprised of the header (row 1) and then a single row in the body. The columns are: Apples Bananas Total Fruit I have no data in row 1, it is simply blank. If I input the following code into a vba module, it works fine. Sub Fruit() Dim...

Hello, To simplify what I am trying to do is: If column a = fruit column b = banana/s OR peach/es then concate columns c and d. I have done it by testing FRUIT and BANANA/S as below but I don't know how to also look for PEACH/ES as well to both return true...

Hi All Been a while but I'm stumped. I have a large list of data with a dropdown list that filters out what I need. Only issue is I would like to group a few options preferable using one list. My Example List Apple Banana Orange Cat Dog Mouse Fruit Animal Trick I would like to know how to...

I can do a join/transpose with one column but nothing I have tried will do a join/transpose with the condition being in two columns. Below is a sample of what I am trying to do. Thanks for any help you may give. <colgroup><col width="65" span="4" style="width: 65pt;"></colgroup><tbody>...

Using the formula here: https://exceljet.net/formula/index-and-match-with-multiple-criteria I have an index-match setup with about 5 or 6 different criteria. for simplicity sake, let's say there are only two criteria <tbody> A B C D E 1 FRUIT SIZE PRICE 2 BANANA 10 £6.50 3...

I am trying to create a form in excel. With certain questions the user can select multiple options. For instance: What type of fruit would you like? (I used an active x combo box for this) No Fruit Apples Oranges Pears Grapes I want the user to be able to pick multiple options at once...

Hi first time posting here, any help is much appreciated. I'm trying to create a drop down list to reorder items, the drop down selection would return 3 columns and 25+ rows from a hidden sheet. I can create the drop down, and am familiar with a vlookup but cannot get a return on the multiple...

Hi all, I am having some trouble summing up some data from the dynamic range B2:C15. All the fruit names that populate $B$2:$B$15 belong to to either of the 4 groups. These 4 groups are also dynamic lists. They are: Group1: Range $E$3:$E$15, Group2: Range $F$3:$F$15, Group3: Range...

Hi all, Please help! I need a macro that does the following: User will input the information in the table below. User will then click a button tied to the macro. The macro will return the filled out table in a newly created sheet. For the table created by the macro, the cells will need to...

Full disclosure this is a cross-forum thread (excelgure.ca) since I need to find a solution quickly! https://www.excelguru.ca/forums/showthread.php?9263-Summing-area-of-data-across-multiple-tabs-with-multiple-criteria-array-and-indirect Hi Everyone, I'm spinning my wheels here between index...