Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rolling up the latest date, criteria of range to compare highest d
I have Excel 2002, for XP.
I have a Bill of Materials for assemblies and sub-assemblies at about 2,000 rows. It has been organized into different levels, with 0, 1, 2, 3, 4, and 5 as indicators. Parts at 0 level are the Top Assemblies, 1 is the Sub-Assembly etc. I need to give my supervisor a formula (or formulas, across columns - whatever is necessary), that will ROLLUP the LAST DATE in a section of parts that relate to each other. EXAMPLE: Lvl Part No. Part Name Date Finished 0 100000 Big Assembly ?-??-?? 1 100001 Big Part ?-??-?? 1 100002 Big Bracket ?-??-?? 2 100003 Big Washer 5-1-08 2 100004 Little Bolt 5-6-08 3 100005 Spacer 5-8-08 We need the dates from the Lower Assemblies, to rollup - whichever is the LASTEST date, to the next level, and the latest date of THAT level, to roll up to the next level - until Lvl 0 Top Assembly tells me the absolute date this part would be complete. (Similar to what Project does... only in Excel.) Using IFs and MAX formulas, I can get it to tell me what the highest date of a bunch are. But I don't know how to specify to Excel, so it knows when one whole assembly has stopped (probably the 0), and NOT to look in the NEXT part's dates and pull date from that. Any advice? Tomorrow is my last day on this project unfortunately. Thanks for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highest Date based on a number of criteria | Excel Worksheet Functions | |||
Compare number to range; find highest positive difference | Excel Worksheet Functions | |||
From range and criteria select highest value | Excel Discussion (Misc queries) | |||
Lookup / return latest date in range AND value of 1 column to the | Excel Worksheet Functions | |||
Lookup the latest date in a range so it appears as my result | Excel Discussion (Misc queries) |