Range with variable start

[Maxdehaas]

Hi all,

I've been trying to combine the Min(B:B) formula with a variable startdate in column A. Can you help me find a way to combine the MIN formula with a variable data range? Thanks!

[Pete_UK]

Do you mean that you want to enter a start date in a cell somewhere (e.g. D1) and then report on the minimum value that is after that start date?

Pete

[berlan]

Hi, see if the attached could be of help.

Cheers, berlan

[Maxdehaas]

Worked brilliantly. Thanks!