ordered

  1. kweaver

    Sorting Issue - not working as expected

    I have a simple sheet that looks like this: more data And, I'm using the following code within other code in VBA: With ActiveSheet.Sort .SortFields.Add Key:=Range("J1"), Order:=xlAscending .SortFields.Add Key:=Range("C1"), Order:=xlAscending .SetRange Range("A1:V" & LRX)...
  2. R

    Calculating time

    Hello, I have been racking my head on how to solve my time issue on my train sheet. I have a train time sheet to show if a train is on time or late Ex; if a train is set and ready to go at 01:30 and the crew is ordered at 03:30 i can show it to say 2:00 on time between these two times. but...
  3. T

    HELP with INDEX formula. Need IMMEDIATELY

    I created a table to record ordering items, and have 2 columns (a Date, and a Qty) for each week of the year, per quarter, to record the Date Ordered and Quantity Ordered. I have 2 columns (at the end of each quarter) which I want the Last Date Ordered to appear in one column, and Last QTY...
  4. M

    Count non blanks 5 years from the last non blank date

    I have a sheet with the column headers as dates by month and year. Column A is "Jan 2002", Column B is "Feb 2002" etc until Column HC "May 2019". In Column HG I have a the date of the last time my customer ordered "Aug 2007" for example. For each month there is either a dollar amount or it is...
  5. M

    Moving Complete Rows Based On Cell Value In Column D

    Hi All, I am trying to complete a parts ordering system for work with my limited excel knowledge. I currently have 15 worksheets with various names & each sheet has 5 x columns: A=Item B=Description C=Cost D=Order E=Total. What I need to happen is when a quantity is entered into Column D, that...
  6. jeff_miller

    Show list of customers that have not ordered

    I have 4 reports that I get The data in these reports is simple, It contains one column with the customer code and a second column with an order entry date The 4 reports are Orders for the last two years Orders for the last Month Orders for the last 3 weeks Orders for the last two weeks I...
  7. pcorpz

    lookup with multiple criteria including date range

    Hi mvps! My goal is to find out the vendor that the customer ordered from. In my lookup table (AP Report), I have the vendor name, and my criteria columns: customer name, itemnumber and the posting date. The customer and item number are exact matches, the posting date however, can be the same...
  8. E

    IF return of 0 then show "Ordered"

    hi, I have the formula below which works perfectly until it returns 0 if nothing is found Can I have the formula changed to show "Ordered" if 0 is found =IF(ET3&EV3="","",IFERROR(LOOKUP(9.99999999999999E+307,1/(('Chase Details'!$F$10:$F$1009=ET3)*('Chase Details'!$G$10:$G$1009=EV3)),'Chase...
  9. A

    Multi-sheet Pivot Table

    Hello, I'm new at this and trying my hardest to create a pivot table that reads multiple worksheets in my file - but I keep hitting brick walls! I'm wondering if anyone is able to help me, pretty please? My file is for someone who has customers ordering beauty products from her. Each...
  10. E

    Ordered Count for each Unique Entry

    I have data in longitudinal format for patients. Each row denotes a treatment with patient column for Patient ID and date of treatment. I need a formula to work out an ordered count for each patient for their first treatment, second treatment, third treatment etc.
  11. D

    2nd Largest Value With Criteria and avoiding duplicates

    Hello, I need to figure out how to grab the 2nd largest value with criteria and avoiding duplicates. essentially i have a list of transactions and I need to say what is this customer's last time they ordered and 2nd to last time they ordered. Thank you so much!
  12. K

    Is it possible?

    Hi, I want to know if what I am thinking is possible and if so what should I Google to find out more? I have 5 workbooks, each workbook represents five different branches of a company and each workbook has worksheet tabs from January to December (12 tabs in total) in which an invoice is for...
  13. J

    Conditional Formating with formula

    In column A I have over 10,000 inventory items where there are some duplicates. (I cannot remove the duplicates this list has to remain in this order) in Column B I am entering the amount that I need to order Is there a way when i enter a qty in column b and I have already ordered that item...
  14. D

    VBA Loop Through to Create Specifically Ordered Array

    Is it possible to loop through a series of textboxes to create an array in a specific order? In a userform, I have 17 textboxes named "txtG1" through "txtG17". I would like to loop through and build an array to pass to the workbook vs. passing each value independently. The code below loops...
  15. M

    Multiple IF Condition

    Hello Guys, I have my sales report in a table starts from column I7 to M7. In I column i have my product name, in J column order status and in M column quantity of the product. My requirement is IF cell content in J column reads ordered and M column cell content reads quantity as 5, then the...
  16. M

    SUMPRODUCT of two arrays but not necessarily in the same order (Index/match/IFs?)

    Hi guys, I want to obtain the sumproduct of the following two arrays, essentially 1 x 0.2 + 2 x 0.1 + 3 x 0.3. A 1 B 2 C 3 B 0.1 A 0.2 C 0.3 SUMPRODUCT would work neatly if the first column in both these arrays were identically ordered (i.e. ABC and ABC). But because they're not so, it...
  17. L

    Counting Orders

    Hello All, I am trying to count orders placed from one sheet in a workbook to another sheet. I'm trying to do it by part number and month range. For instance, I have sheet1 that I keep a running tab of orders placed; part #, date ordered and quantity. On sheet two, I have; description, part#...
  18. A

    Moving row to another sheet based on cell yalue

    I'm pretty clueless when it comes to coding and need some help with this excel file. I'm trying to insert a code that will move an entire row from sheet "Ordered" to sheet "Invoiced" when yes is selected from the drop down list in column M. I'd like it to not leave any blank lines on the...
  19. D

    barcode to spreadsheet including master spreadsheet

    Hi All, i am trying to set up a small system so i can scan a barcode from my android phone which then refers to a barcode master sheet (that i can replace at any time) to look up info and then puts that info ito a spreadsheet. info would be as follows in colums:- barcode, model, description...
  20. E

    SUMIF function with SUMBYCOLOR function

    Hello. Is there a way to use other functions with the SUMBYCOLOR function? I've not been able to get it to work. I would like to sum data that has a specific background color, within a specific date range, containing specific text "Widget #1 " or "Widget #2 ". Example: Summarized data should be...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top