Results according to selected date range

[madocar]

Hello,

I would like to ask you for help. I need to get the results according to selected value (date range). Could you help me please?

Excel file in attachment.

Thanks a lot

 

[Chihiro]

Are you opposed to just having single row header? (IE. Single page A, page B, page C...) Also, I'd recommend having no blank columns to make thing simpler.

See if attached meets your needs.

 

[madocar]

Hi Chihiro,
the thing is there is more column (5) connected to that particular date.
In the example workbook is just one column connected to one date.
Hope that helps

Thanks

 

[Chihiro]

Ok that would change things a bit.
Can you upload example with complete set of data so formula can be adjusted?

 

[madocar]

It looks like this

Thanks a lot

 

[Chihiro]

See if attached meets your need.

I've adjusted a bit and can grab all data for each date.

Note that CHOOSE has value limit of 254. If you require more... I'd recommend reorganizing your data and using index,match or other variations.

 

[madocar]

Thanks a lot Chihiro!!!