Hi Guy,

I would have thought that Rows 3, 1 and 7 would be the lowest?

Have you tried Autofilter, that could give you the lowest 10, and that
should be easy to work from?

Otherwise, you need to look at a macro

"Guy" wrote:

Hi

I have a spreadsheet that has a date column A and a stock level column Z.
Due to stock coming in and going out at different times of the same day there
are often a number of dates the same in col A (time is recorded separately in
col B) and varying values in col Z.

I need to produce a graph of the lowest stock level from every day on which
the stock level changes.

Thus:-

A Z
1 1/1/5 100
2 1/1/5 150
3 1/1/5 99
4 1/1/5 120
5 2/1/5 130
6 2/1/5 120
7 6/1/5 100
8 6/1/5 150
9 6/1/5 175
etc

Therefore I want to be able to hide/delete (somehow?) all but row 3, 6 and 7
in this example so I can use the remaining rows date and stock levels for the
graph.

Thanks, any help would be greatly appreciated.

Guy.