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

Please Login or Register  to view this content.