apples

Hi, I'm trying to see if its possible to do in excel or to build a macro for the following situation: We have multiple types of apples (Fuji, Red, Gala, Golden, HoneyCrisp, and Green). All apples are each uniquely barcoded that are evenly distributed into 6 baskets. When it comes to uneven...

Hi i have more than 50 workbooks with same data but i need specified columns in one workbook example sharing for your Reference [Crazy Mart]-Workbook1 <tbody> Item Name Price Oranges 50 Apples 35 Banana 25 Pomegranate 60 </tbody> [Trail Mart]-Workbook2 <tbody> Item Name Price...

<tbody> A B C Oct 2019 % Share Vegetables Apples 10 50 Lettuce 10 50 Total 20 100 Fruits Oranges 10 50 Blueberries 10 50 Total 20 100 </tbody> Hi guys, little bit of an involved question here. The above is an example of my table for sales. I currently have two...

Hi everyone, I'm hoping one of you excel geniuses might be able to help me out.. I have a spreadsheet with data filled from F2 - F650. In that column there are some duplicates. In Column G I want to use a formula to identify only the duplicates and not the initial entry. So for example I...

I am trying to compare numerical amounts on different sheets/tabs for common criteria, for example sales of an item on two months to determine the difference. I have a vlookup for this, but would prefer an index match The sheets would be as follows sheet 1 row 1 row 2 apples...

Hello, I'm trying to use a sumproduct formula to pull in data from a table with 3 criteria, but I need one criteria to reference a table. Here's an example of what I'm trying to do. I'm trying to pull how many apples Chris sold in each state. Sheet 1 <colgroup><col...

I have a table with different dates in column A <tbody> a b c d 2017-01-15 Apples 5 2017-02-15 Apples 4 </tbody> I also have a list with different prices depending on the time of date. <tbody> 2017-01-01 25,5 $ 2017-02-01 27,6 $ 2018-01-01 32,4 $ </tbody> I want to make a...

Good Evening, In one "master sheet" in cell "A1" I have the date 1/1/2020. This cell / date controls many other formulas in my workbook. In cell "B2" of another sheet I have a formula that equals cell "A1" in my master sheet. I need cells "B3" and below to proceed with 1/2/2020, 1/3/2020, etc...

I have the following data in columns E and F. In G via a loop I am trying to populate - I have given a few examples in the right column as to how it should look. This attempt isn't quite working. Sub Loop1() Dim i As Integer Dim j As Integer NumberRows =...

Good Afternoon All; I am running into an issue I can't resolve with a data export. The data exports with what I suppose would be called a "Header" row, with the corresponding data in the rows beneath. There is no certain number of rows beneath, and due to the size of the file I can't do this...

Hi, I would like to be able to take a quantity and "round" it based on a list of rounding criteria. I am having trouble trying to find an exact example of what I an trying to do nor am I having any luck myself with the different formulas. I have created an example using fruit if someone could...

I'm stumped. Been trying this all morning. I have an excel file with two sheets: A. Master List + Output -- contains the base list of value that I want to check presence for against in all other columns in the "Daily Orders" sheet. B. Daily Orders -- contains lists of each day's purchased...

Sorry for the vague description but not sure how best to describe this. Here is the situation below. I want column C to be a formula. Out of all of the occurrences of Oranges in column B, if any of them have a value of 5 or above in column A, then I want it to return a Y in column C for all...

Hello, all. I don't seem to be able to find this specific variant of a value-matching formula. I'm trying to output the list in column "ValueIsPresentInA-B-C", where it checks all of the other columns for values that must be present in each each of the others and then populates the column. The...

i have a spreadsheet with multiple columns. One of these columns have a numeric value. I want excel to group the data based on a sum on this column. example: each line has 2 columns, one a name and one a value (which is a point). line 1 apples 5 line 2 pears 3 line 3 grapes 4 line 4 grapes 2...

Hi all, I am trying to find the best way to fill up a dynamic table with the right values as easily as possible (hopefully one click) once I input the the order number and it's details. I am stumped not sure whether I'll need to use helper columns / vba. I wanted to get the answers to the "To...

I have a list of values that is seperated by a return. How do I sort each cell in alphabetical order without moving the row? EXAMPLE. CURRENT DATA <tbody> 1 APPLES GRAPES WATERMELON BANANA CHEERY 2 PINK BLUE GREEN YELLOW 3 APRIL AUGUST JULY DECEMBER JUNE </tbody> WANTED RESULTS <tbody>...

Hi there, I have a data set and Im trying to look up a specific value based on an initial look up in one column and then a secondary look up in another. So data would look something like this: A B C Apples Granny Smyth...

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

Hello, I want if it contains a predefined value in a cell, to delete that row but not before to add the value that it has to the upper one, example below: A B C 1 apples 30 2 orange 105 3 test 5 4 carrot 40 5 test 10...