Hi there! I am new to this forum and so please excuse me if this comes across a bit newbish. I'm working on a spreadsheet (see the attachment) that has routenames, start milepoints, endmilepoints, year and some condition data attached to it. What I want to do is this as follows-
For a cell in A2 (routename), find all the years that is attached to it (year ranges can be from 2007 TO 2013), filter out I2 coumn (Year) to see only the most recent year, and see all the other data in other columns attached to this year.
For eg, say if I select the first route, A2 is 016SC00600EB, year associated with that route is 2008 and 2013. I only want data in columns associated with 2013 to be displayed.
And I want this to be done to all the routes in Column A. Since there are more than a 100 routes, what's the best way to approach this.
For a cell in A2 (routename), find all the years that is attached to it (year ranges can be from 2007 TO 2013), filter out I2 coumn (Year) to see only the most recent year, and see all the other data in other columns attached to this year.
For eg, say if I select the first route, A2 is 016SC00600EB, year associated with that route is 2008 and 2013. I only want data in columns associated with 2013 to be displayed.
And I want this to be done to all the routes in Column A. Since there are more than a 100 routes, what's the best way to approach this.