Select only rows close to specific date

[Fjeldgaard]

Hi,

I have a database in Excel, where Column A have 100 specific values, that are updated each month, and column B have a price, and Column C have the date which the values have been updated. But some month not all values are updated may only 60 or so.

I need a way to get the values closest to a choosen date, as I sometimes have to make som control of earlier data.

My guess was to to have a cell where a could input a given date, and then Excel will find the unique values closest to the given date and before it. But I can not find a way to due this. I would like it to be formulas, but macros could also be okay, if it couldn't be done with formulas without the sheet being to heavy.

I hope someone can help?

 

[Lukasier]

By closest you mean if you give 10.02.2020 it should give 9.02.2020 and 11.02.2020 or only 9.02.2020 because its before it?

 

[Fjeldgaard]

Fx. if I have a dataset like the below, and my input date is 2020-03-01, then the price values 370.00 and 110.00 should be the one showed.

ID	Price	Date
105	350.00	2020-01-15
210	99.00	2020-01-15
105	340.00	2020-02-18
105	370.00	2020-02-29
210	110.00	2020-02-29
105	330.00	2020-03-31