Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
im trying to pick up the date with the highest version number for each stage
for each ID (there could be infinite versions). i have no idea where to start!! ID Stage Version # Date 169646 Feasibility 0 1/02/2005 169646 Conceptual 0 13/03/2005 169646 Definition + Design 0 1/04/2005 169646 Definition + Design 1 3/06/2005 169646 Build + Implement 0 5/07/2005 169646 Build + Implement 1 23/07/2005 169646 Build + Implement 2 12/08/2005 123497 Feasibility 0 1/09/2005 123497 Conceptual 0 25/10/2005 123497 Conceptual 1 4/11/2005 really appreciate your help here, thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to find oldest date in ever changing list. | Excel Worksheet Functions | |||
Find Max after a date | Excel Worksheet Functions | |||
find date in Col A corresponding to min value in Col B | Excel Worksheet Functions | |||
Need to find Min value based on date range entered | Excel Worksheet Functions | |||
Need to find Min value based on date range entered | Excel Worksheet Functions |