Hello there,

I have a problem...

I have a sheet of values and one certain column tells me if the line item is
either a but order or a sell order - nominated by either "True" (for sell
orders) or "False" (for buy orders),

I would like to be able to return the most minimum value of all the "False"
lines within the sheet also on a separate formula return the MAX of the
"True" lines.

i have tried a mixture of formula's from DMIN to IFs and MINs and INDEX and
MATCH... it is frustrating me now!!!

Many thanks...