apples

  1. 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...
  2. 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...
  3. F

    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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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 =...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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>...
  17. 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...
  18. 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...
  19. 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...
  20. C

    vlookup base on a maximum/latest condition

    Hi guys, I am having trouble with a formula to determine the latest value on a vlookup. The following is an example: <tbody> Apples ordered 2/4/2019 Oranges backfilled 2/4/2019 Apples arrived 3/4/2019 Oranges arrived 3/4/2019 Apples backstock 4/4/2019 Oranges missing 4/4/2019...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top