Index / Match / Min

[LanceLance]

Morning.
What I am looking to do/ need help with is:
Looking at blocks of data (top table) and trying to get all data from a certain date entered in to “Review Date” to appear in Results table
Lookup date in “Review Date” and in row 1 of results table display date and earliest time based on date.
Problem is lets say for 9^th October 2012 how do I get dates and times in order (earliest to latest) in the results table?
Know once I get dates and times in the results table I can use a =Index/Match function to gather the data from Colum A,B,C,D,E,F and G
but just cant get dates in order?
Maybe an Index/Match/ Min formula?

Data
Date	Time	A	B	C	D	E	F	G
06-Oct-12	02:42	1	52757.76	864.59	58.29	57.87	16.33	13.49
06-Oct-12	9.59	1	78048.6	865.25	57.82	57.73	16.6	13.19
06-Oct-12	11:20	1	79691.94	866.01	57.77	57.78	16.6	13.23
06-Oct-12	15:30	1	64107.18	865.3	58.66	58.47	16.72	13.42
08-Oct-12	08:38	1	66292.06	859.81	56.84	56.79	16.48	13.72
08-Oct-12	11.07	1	60592.04	859.31	56.8	56.75	16.44	13.7
08-Oct-12	15:30	1	62171.2	859.11	56.54	56.51	16.4	13.46
09-Oct-12	02:42	1	61497.04	858.32	56.36	56.29	16.41	13.37
09-Oct-12	9.59	1	61705.62	837.92	56.54	56.53	16.55	13.38
09-Oct-12	11:20	1	62269.61	857.99	56.59	56.58	16.54	13.36
09-Oct-12	15:30	1	59384.2	858.21	56.46	56.42	16.4	13.36
09-Oct-12	23:17	1	57483.99	858.35	56.65	56.6	16.39	13.34
18-Oct-12	9.59	1	58971.89	857.51	55.97	55.94	16.5	13.59
09-Nov-12	23:17	1	0	0	0	0	0	0
03-Apr-14	21:22	1	70900.7	859	60.07	60.1	16.72	13.22
04-Apr-14	11:20	1	94072.88	906.65	59.3	59.8	17.25	12.99
05-Apr-14	02:42	1	97737.14	906.91	59.31	59.33	17.2	13.14
05-Apr-14	9.59	1	98166.31	910.03	59.15	59.18	17.22	13
11-Apr-14	11.07	1	61806.5	855.512	58.95	58.74	16.98	13.17
11-Apr-14	15:30	1	65163.83	856.27	59.03	58.78	16.97	13.18
Review Date	09/10/2012
Results
Date	Time	A	B	C	D	E	F	G
09/10/2012

<colgroup><col style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;" width="85"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" width="75"> <col style="width: 48pt;" span="7" width="64"> <tbody>
</tbody>

Thanks Lance

 

[StefanVL]

I'd add an extra column before date, in the result table called idx,

in this column put:

=IFERROR(SMALL(IF($A$2:$A$21=$M$2;ROW($A$2:$A$21)-ROW($A$2)+1;"");ROWS($K$6:K6));"")

ENTER WITH CTRL + SHIFT + ENTER

then in the first cell under date put:

=IF($K6="";"";INDEX($A$2:$I$21;$L6;Match(L$5;$A$1:$I$1;0)))

K6 is the column where i've put the top formula, L5 is the first header of the result table.

See end results in table below

	Results
idx	Date	Time	A	B	C	D	E	F	G
8,00	09-Oct-12	0,1125	1	61497.04	858.32	56.36	56.29	16.41	13.37
9,00	09-Oct-12	9.59	1	61705.62	837.92	56.54	56.53	16.55	13.38
10,00	09-Oct-12	0,4722222	1	62269.61	857.99	56.59	56.58	16.54	13.36
11,00	09-Oct-12	0,6458333	1	59384.2	858.21	56.46	56.42	16.4	13.36
12,00	09-Oct-12	0,9701389	1	57483.99	858.35	56.65	56.6	16.39	13.34

<tbody>
</tbody>