Get Max and Min value for Selective date

Hi
I am having excel work book with two sheets Nifty and KEY
In My workbook nifty price is be available for every min in NIFTY sheet. I want particulate dates High
Eg: Get 10 Aug 2015 High nifty price from NIFTY sheet, after getting days high value I need to get corresponding Open,Close,Low,High in KEY sheet ROW 6.
Respectively I want to get for Low also. Date want to get from KEY sheet "B2" .

Currently I am Filtering Respective date and then sorting high to low value for High value and lowest to high for Low value and then I am copy pasting into KEY sheet this took lots of time. Kindly help to solve this using VBA.

I have given the excel sheet with exact data.

NIFTY.xlsx

Hi try these array formulas in the attachment
In E6

Please Login or Register  to view this content.

In E7

Please Login or Register  to view this content.

then in B6

Please Login or Register  to view this content.

As for other cells just copy the formula in B6 and select other cells (B7 - C6:D7 - F6:G7) and right click then paste special and select formulas

The formula is working good I tested it with 11th Aug ..
In NIFTY filtered data based on the date 11th Aug the sort the data based on column E and I got the same results for highest and lowest value

To customize the formmula just change the end of the ranges e.g repalce 1400 with 2000 in all the formulas and don't forget to press Ctrl + Shift + Enter as these are array formulas

The file is ok for me again
You filter data based on date ok .. then select filtered date and sort data based on Column E

My results are correct exactly as the data appeared in NIFTY sheet

It seems that I missed something ..
I don't know about stock ..so I didn't realize you sort for high based on column E but for low based column D
Here's the correction

You're welcome
Thanks for the feedbakck and for the rep. points
Regards

Hi barathsoft
Can you specify exactly where is the error you mean and the expected results?

Hi Yasheer
Sorry.....!
In KEY Sheet B2 is for day one and j2 is for Day two these two tables is for stock to find open close High Low and date. B4,B5,B8 will be inserted using macro. B6 and B7 will get date using index match which is suggested by you. B12 and J12 table will get date from stock and it will do Vlookup for that particular date for NIFTY. like this I am calculating for last two days data for my calculation.same calculation I added for two more days B20 and J20 tables also B38 and J38. currently I am not getting high and Low value for some dates. Problem may be with DL or Range in formula but I could spot the error. I am having problem in Row 6, 7, 24, 25, 42, 43 to find the min and max value. One more think each time I am running my macro DL data range may differ is that also a problem, I kept default range as 5400 in your formula. If you need any clarification ask me please.

This formula worked for more than 10 days data. After changing the data in DL problem started. which means when i updated DL data everything went wrong.

Help me yasheer

I think it would be better to present this issue in another thread and give more details and attach your file with expected results..
I am sure you will find assistance