I have a spreadsheet laid out kind of like this:
Date Project#
2012-01-01 130
2012-01-02 153
2012-01-03 153
2012-01-04 130
2012-01-05 130
2012-01-06 130
And I want to get the min/max dates for those rows where Project# matches a variable, to produce this:
Projects Start date End date
130 2012-01-01 2012-01-06
153 2012-01-02 2012-01-03
I figured I could do it via VLOOKUP and searching in both directions, but I can't get it working properly. It all works fine as long as the project numbers are all grouped together, but if they're interleaved as in the example it does not work anymore. It only returns from the top-most grouping, so I'd get project 130's end date as 2012-01-01 instead.
I'm a bit of a spreadsheet newbie, so any help would be greatly appreciated.
Thanks!