Find Start and End date from two reference column

[Ganesankadarkarai]

Dear Experts,

I need a help on Excel Reporting, I have the data like below, Where "Value" column is Unique. when I search the value from value column, should check the first name from "Name" column and related date column value should be placed in start cell.

May be my way of explanation is wrong. please find the attached excel sheet. may be experts could understand well my problems.

Date Value Name
1/1/2013 10 A Start
1/2/2013 11 B
1/3/2013 12 C
1/4/2013 13 D
1/5/2013 14 E
1/6/2013 15 A End Search value 10 Search value 20
1/7/2013 16 B
1/8/2013 17 C Result Start End Result Start End
1/9/2013 18 D 1/1/2013 1/6/2013 1/11/2013 1/20/2013
1/10/2013 19 E
1/11/2013 20 A Start
1/12/2013 21 B
1/13/2013 22 C
1/14/2013 23 D
1/15/2013 24 E
1/16/2013 25 F
1/17/2013 26 G
1/18/2013 27 H
1/19/2013 28 I
1/20/2013 29 A End
1/21/2013 30 B
1/22/2013 31 C

[:) Sixthsense :)]

In J15 Cell - Array Formula - Requires CTRL+SHIFT+ENTER

=INDEX($D$7:$D$28,SMALL(IF(($E$7:$E$28>=J12)*($F$7:$F$28="A"),ROW($F$7:$F$28)),1)-ROW($E$7)+1)

In K15 Cell - Array Formula - Requires CTRL+SHIFT+ENTER

=INDEX($D$7:$D$28,SMALL(IF(($E$7:$E$28>=J12)*($F$7:$F$28="A"),ROW($F$7:$F$28)),2)-ROW($E$7)+1)

Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.