OpenOffice Calc (spreadsheet) - a formula / function?

[bibblebub]

Currently trying to diet, I have been keeping a record of my weight each week in the form of a table with a column of dates (in reverse chronological order) and a corresponding column of weights.

What I want to do is to be able to display that my current weight is the lowest it has been since whenever it was last lower i.e. I want to search the table, going down the column of weights until I find the first entry that is less than the current value and to use the date corresponding to that weight (i.e. display that date in a cell next to the current weight).

If I were writing code then I would use a simple loop to examine each entry in turn, but there doesn't seem to be an equivalent function in a spreadsheet. Does anyone know how to do it?

Thanks in advance.

[ChuckFickens]

Can you not just sort the sheet by the weight column ?

[bibblebub]

There must surely be a way of doing it that doesn't rely on having to manually inspect the entries.