Formula for finding Start, Stop, Highest and Lowest value

Dear Excel pros!

I want to find and extract the following information from a matrix:

- The first registered value within a specific date ("Start")
- The last registered value within a specific date ("Stop")
- The highest registered value within a specific date
- The lowest registered value within a specific date

(This will look very much like a table of stock values).

So I need the four formulas to find this information within a table ("'Table 1") and copy the data to a new table ("Table 2").

Please see the attached file for more information.

Thank you in advance!

Try in...

G5=INDEX(Tabell1[Start],MATCH([@Date],Tabell1[Date],0))

H5=LOOKUP([@Date],Tabell1[Date],Tabell1[Stop])

I5=MAX(OFFSET(Tabell1[[#Headers],[Start]],MATCH([@Date],Tabell1[Date],0),,COUNTIF(Tabell1[Date],[@Date]),2))

J5=MIN(OFFSET(Tabell1[[#Headers],[Start]],MATCH([@Date],Tabell1[Date],0),,COUNTIF(Tabell1[Date],[@Date]),2))

Or try this

=INDEX(Tabell1[Start],1/AGGREGATE(14,6,1/(--(Tabell1[Date]=$F5)*(ROW(Tabell1[Date]))),1)-ROW(Tabell1[#Headers]))
=INDEX(Tabell1[Stop],AGGREGATE(14,6,(--(Tabell1[Date]=$F5)*(ROW(Tabell1[Date]))),1)-ROW(Tabell1[#Headers]))
=MAX(AGGREGATE(14,6,(--(Tabell1[Date]=$F5)*(Tabell1[Start])),1),AGGREGATE(14,6,(--(Tabell1[Date]=$F5)*(Tabell1[Stop])),1))
=MIN(1/AGGREGATE(14,6,1/(--(Tabell1[Date]=$F5)*(Tabell1[Start])),1),1/AGGREGATE(15,6,1/(--(Tabell1[Date]=$F5)*(Tabell1[Stop])),1))