Hi team, I'm new to the Excel Forum as well as for the excel also.
I have a issue in the excel, that I need to take the result as follows.
Date Value
1/1/2013 10
1/2/2013 10
1/3/2013 10
1/4/2013 10
1/5/2013 10
1/6/2013 12 Search value 10
1/7/2013 12
1/8/2013 12 Result Start End
1/9/2013 12 1/1/2013 1/5/2013
1/10/2013 12
1/11/2013 12
1/12/2013 12
1/13/2013 15
1/14/2013 15
1/15/2013 15
1/16/2013 15
1/17/2013 15
1/18/2013 15
1/19/2013 15
1/20/2013 15
1/21/2013 15
1/22/2013 15
I need to find the start and end date's from the date column from the search value from value column, I have attached my excel sheet also.
hope I explained my question well.
please help me to resolve this.
Bookmarks