Results 1 to 8 of 8

bill of materials

Threaded View

stevekirk bill of materials 12-10-2006, 06:10 AM
Bryan Hessey Hi, This could be more a... 12-10-2006, 07:21 AM
stevekirk bryan, i thought this... 12-10-2006, 07:57 AM
Bryan Hessey Steve, I saw your note... 12-10-2006, 08:40 AM
stevekirk BRYAN, Not sure if it is... 12-10-2006, 09:23 AM
Bryan Hessey ok - thats a little different... 12-10-2006, 10:13 AM
stevekirk byran, i did not copy the... 12-10-2006, 11:21 AM
Bryan Hessey Steve, assuming you mean... 12-10-2006, 05:12 PM
  1. 12-10-2006, 10:13 AM #6
    Bryan Hessey is offline
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by stevekirk
    BRYAN,

    Not sure if it is working or not dont think so
    look at the attached it will help better

    it is one part used in 2 high level parts

    total high level 124 of which 13 in stock
    total number of the same lower part 124
    one per high level
    number of orders per lower level 124
    i want the first 13 lower level order to be deleted as they are within the stock of the higher level part

    steve
    ok - thats a little different sheet, but, in Q2 put

    =IF(MATCH("Description",A:A,0)>=ROW(A2),"",IF(ISERROR(VLOOKUP(D2,INDIRECT("F1:H"&MATCH("Description",A:A,0)),3,FALSE)),"",VLOOKUP(D2,INDIRECT("F1:H"&MATCH("Description",A:A,0)),3,FALSE)))

    and fill that down, is that the 13 to remove?
    ---

    added note, there are no spaces in that formula
    Last edited by Bryan Hessey; 12-10-2006 at 10:20 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1