apples

  1. L

    Sorting Apples pt. 3

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

    Copy Specified Columns from Multiple Workbooks to one Workbook

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

    VBA - Replacing cell values based on specific range

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

    Finding Only One Duplicate

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

    using index match to compare numbers on different sheets based on a common criteria

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

    SUMPRODUCT / INDEX MATCH Question

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

    If date < = list range, return value

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

    Repeat Values and Range of Dates Based on Cell Values

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

    VBA Loop

    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 =...
  10. L

    Placing Row Titles in Rows Below

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

    Round Value Based On Criteria

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

    Check a list of values against multiple columns and output a list that appears in each?

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

    Formula merging a countif with a second if statement

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

    Print Column of Values Present in all Each Other Column

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

    formula for grouping data

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

    Sequence filling of table for order picking based on current inventory

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

    Sort Contents Within 1 Cell

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

    Help needed - VLOOKUP based on IF statement, or similar

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

    using SMALL, INDEX, with IF conditional adding a HYPERLINK

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

    button to delete row and update another row

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top